IDatabasePerformanceFacet IDatabasePerformanceFacet IDatabasePerformanceFacet Interface

Definition

Important

This API is not CLS-compliant.

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

public interface class IDatabasePerformanceFacet : Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet
[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayDescriptionKey("IDatabasePerformanceFacet_Desc")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayNameKey("IDatabasePerformanceFacet_Name")]
[Microsoft.SqlServer.Management.Sdk.Sfc.LocalizedPropertyResources("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[System.CLSCompliant(false)]
[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter))]
public interface IDatabasePerformanceFacet : Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet
Public Interface IDatabasePerformanceFacet
Implements IDmfFacet
Derived
Attributes
Implements

Properties

AutoClose AutoClose AutoClose

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

AutoShrink AutoShrink AutoShrink

Indicates whether the database files are candidates for periodic shrinking.

CollationMatchesModelOrMaster CollationMatchesModelOrMaster CollationMatchesModelOrMaster

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

DataAndLogFilesOnSeparateLogicalVolumes DataAndLogFilesOnSeparateLogicalVolumes DataAndLogFilesOnSeparateLogicalVolumes

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

IsSystemObject IsSystemObject IsSystemObject

Indicates whether the database performance facet is a system object.

Size Size Size

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

Status Status Status

Gets the database status.

Applies to