Condividi tramite


DatabasePerformanceAdapter Class

Definition

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
DatabasePerformanceAdapter
Implements

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