Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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))]
[DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")]
[CLSCompliantAttribute(false)]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public interface IDatabasePerformanceFacet : IDmfFacet

The IDatabasePerformanceFacet type exposes the following members.

  NameDescription
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.
Top

Community Additions

ADD
Show:
© 2015 Microsoft