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)

public interface IDatabasePerformanceFacet : IDmfFacet

The IDatabasePerformanceFacet type exposes the following members.

Public propertyAutoCloseGets or sets a value that indicates whether the database will be closed automatically after the last user exits.
Public propertyAutoShrinkIndicates whether the database files are candidates for periodic shrinking.
Public propertyCollationMatchesModelOrMasterGets a value that indicates whether the collation of the database matches the master or model database.
Public propertyDataAndLogFilesOnSeparateLogicalVolumesIndicates whether the database has its data and log files on different logical volumes.
Public propertyIsSystemObjectIndicates whether the database performance facet is a system object.
Public propertySizeGets the size of the database in megabytes (MB).
Public propertyStatusGets the database status.

Community Additions

© 2015 Microsoft