IDatabasePerformanceFacet Interface

Defines methods and properties that can be used to measure and influence database performance.

This API is not CLS-compliant. 

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")> _
<CLSCompliantAttribute(False)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")> _
Public Interface IDatabasePerformanceFacet _
    Inherits IDmfFacet
'Usage
Dim instance As IDatabasePerformanceFacet
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")]
public interface IDatabasePerformanceFacet : IDmfFacet
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayDescriptionKeyAttribute(L"IDatabasePerformanceFacet_Desc")]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute(L"IDatabasePerformanceFacet_Name")]
public interface class IDatabasePerformanceFacet : IDmfFacet
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")>]
[<DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")>]
[<CLSCompliantAttribute(false)>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")>]
type IDatabasePerformanceFacet =  
    interface 
        interface IDmfFacet 
    end
public interface IDatabasePerformanceFacet extends IDmfFacet

The IDatabasePerformanceFacet type exposes the following members.

Properties

  Name Description
Public property AutoClose Gets or sets a value that indicates whether the database will be closed automatically after the last user exits.
Public property AutoShrink Indicates whether the database files are candidates for periodic shrinking.
Public property CollationMatchesModelOrMaster Gets a value that indicates whether the collation of the database matches the master or model database.
Public property DataAndLogFilesOnSeparateLogicalVolumes Indicates whether the database has its data and log files on different logical volumes.
Public property IsSystemObject Indicates whether the database performance facet is a system object.
Public property Size Gets the size of the database in megabytes (MB).
Public property Status Gets the database status.

Top

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace