This topic has not yet been rated - Rate this topic

IDatabasePerformanceFacet Interface

SQL Server 2012

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)

Syntax

C++

JScript

[DisplayNameKeyAttribute("IDatabasePerformanceFacet_Name")]
[DisplayDescriptionKeyAttribute("IDatabasePerformanceFacet_Desc")]
[CLSCompliantAttribute(false)]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public interface IDatabasePerformanceFacet : IDmfFacet

The IDatabasePerformanceFacet type exposes the following members.

Properties

	Name	Description
	AutoClose	Gets or sets a value that indicates whether the database will be closed automatically after the last user exits.
	AutoShrink	Indicates whether the database files are candidates for periodic shrinking.
	CollationMatchesModelOrMaster	Gets a value that indicates whether the collation of the database matches the master or model database.
	DataAndLogFilesOnSeparateLogicalVolumes	Indicates whether the database has its data and log files on different logical volumes.
	IsSystemObject	Indicates whether the database performance facet is a system object.
	Size	Gets the size of the database in megabytes (MB).
	Status	Gets the database status.

Top

Reference

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD