DatabasePerformanceAdapter Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Management.Smo

Assembly:: Microsoft.SqlServer.Smo.dll

Package:: Microsoft.SqlServer.SqlManagementObjects v150.18208.0

Package:: Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

The Database Performance facet implements logical properties and requires overriding Refresh and Alter Thus it is a new class.

public class DatabasePerformanceAdapter : Microsoft.SqlServer.Management.Smo.DatabaseAdapterBase, Microsoft.SqlServer.Management.Facets.IDmfAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.IDatabasePerformanceFacet

type DatabasePerformanceAdapter = class
    inherit DatabaseAdapterBase
    interface IDmfAdapter
    interface IDatabasePerformanceFacet
    interface IDmfFacet

Public Class DatabasePerformanceAdapter
Inherits DatabaseAdapterBase
Implements IDatabasePerformanceFacet, IDmfAdapter, IDmfFacet

Inheritance: Object

DatabaseAdapterBase
DatabasePerformanceAdapter

Implements: IDmfAdapter IDmfFacet IDatabasePerformanceFacet

Constructors

DatabasePerformanceAdapter(Database)

Properties

AutoClose	Returns true if the database has auto-close set to ON. (Inherited from DatabaseAdapterBase)
AutoShrink	Returns true if the database has auto-shrink option enabled. (Inherited from DatabaseAdapterBase)
CollationMatchesModelOrMaster	Returns true if the collation of the database matches master or model.
DataAndLogFilesOnSeparateLogicalVolumes	Returns true if the database has its data and log files on different logical volumes.
Database	(Inherited from DatabaseAdapterBase)
DelayedDurability	Returns delayed durability setting of a database. (Inherited from DatabaseAdapterBase)
IsSystemObject	(Inherited from DatabaseAdapterBase)
LastBackupDate	(Inherited from DatabaseAdapterBase)
LastLogBackupDate	(Inherited from DatabaseAdapterBase)
PageVerify	Returns true if the PAGE_VERIFY setting of a database is set to CHECKSUM. (Inherited from DatabaseAdapterBase)
ReadOnly	Returns true if the database is read-only. (Inherited from DatabaseAdapterBase)
RecoveryModel	Returns the database recovery model. (Inherited from DatabaseAdapterBase)
Size	(Inherited from DatabaseAdapterBase)
Status	(Inherited from DatabaseAdapterBase)
TargetRecoveryTime	Returns target recovery time setting of a database. (Inherited from DatabaseAdapterBase)
Trustworthy	(Inherited from DatabaseAdapterBase)

Methods

Alter()	(Inherited from DatabaseAdapterBase)
DataFileVolumeNotIn(List<String>)	This method compares the drive letter from files in the filegroups against the drive letters in the checkDrives parameter. If any one file drive letter is in the list of checkVolumes, then the function returns true otherwise it returns false. (Inherited from DatabaseAdapterBase)
GetVolume(String)	(Inherited from DatabaseAdapterBase)
Refresh()

Applies to

共用方式為