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)

'Declaration
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")> _
<CLSCompliantAttribute(False)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")> _
Public Interface IDatabasePerformanceFacet _
	Inherits IDmfFacet
'Usage
Dim instance As IDatabasePerformanceFacet

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft