Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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)
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")]
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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.