IDatabasePerformanceFacet Interface
Collapse the table of content
Expand the table of content

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