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)

No code example is currently available or this language may not be supported.

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