TechNet
Export (0) Print
Expand All

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)

[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<CLSCompliantAttribute(false)>]
[<DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")>]
[<DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")>]
type IDatabasePerformanceFacet = 
    interface
        interface IDmfFacet
    end

NameDescription
System_CAPS_pubpropertyAutoClose

Gets or sets a value that indicates whether the database will be closed automatically after the last user exits.

System_CAPS_pubpropertyAutoShrink

Indicates whether the database files are candidates for periodic shrinking.

System_CAPS_pubpropertyCollationMatchesModelOrMaster

Gets a value that indicates whether the collation of the database matches the master or model database.

System_CAPS_pubpropertyDataAndLogFilesOnSeparateLogicalVolumes

Indicates whether the database has its data and log files on different logical volumes.

System_CAPS_pubpropertyIsSystemObject

Indicates whether the database performance facet is a system object.

System_CAPS_pubpropertySize

Gets the size of the database in megabytes (MB).

System_CAPS_pubpropertyStatus

Gets the database status.

Return to top
Show:
© 2016 Microsoft