DatabasePerformanceAdapter DatabasePerformanceAdapter DatabasePerformanceAdapter Class

Definition

The Database Performance facet implements logical properties relevant to database performance management.

public ref class DatabasePerformanceAdapter : Microsoft::SqlServer::Management::Smo::DatabaseAdapterBase, Microsoft::SqlServer::Management::Facets::IDmfAdapter, Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet, Microsoft::SqlServer::Management::Smo::IDatabasePerformanceFacet
public class DatabasePerformanceAdapter : Microsoft.SqlServer.Management.Smo.DatabaseAdapterBase, Microsoft.SqlServer.Management.Facets.IDmfAdapter, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Smo.IDatabasePerformanceFacet
Public Class DatabasePerformanceAdapter
Inherits DatabaseAdapterBase
Implements IDatabasePerformanceFacet, IDmfAdapter, IDmfFacet
Inheritance
DatabasePerformanceAdapterDatabasePerformanceAdapterDatabasePerformanceAdapter
Implements
Microsoft.SqlServer.Management.Facets.IDmfAdapterMicrosoft.SqlServer.Management.Facets.IDmfAdapterMicrosoft.SqlServer.Management.Facets.IDmfAdapter IDmfFacetIDmfFacetIDmfFacet IDatabasePerformanceFacetIDatabasePerformanceFacetIDatabasePerformanceFacet

Constructors

DatabasePerformanceAdapter(Database) DatabasePerformanceAdapter(Database) DatabasePerformanceAdapter(Database)

The Database Performance facet implements logical properties relevant to database performance management

Properties

AutoClose AutoClose AutoClose

Gets or sets a value that indicates whether the AutoClose is on.

(Inherited from DatabaseAdapterBase)
AutoShrink AutoShrink AutoShrink

Gets or sets a value that indicates whether the AutoShrink is on.

(Inherited from DatabaseAdapterBase)
CollationMatchesModelOrMaster CollationMatchesModelOrMaster CollationMatchesModelOrMaster

Specifies if the collation of the database matches master or model.

DataAndLogFilesOnSeparateLogicalVolumes DataAndLogFilesOnSeparateLogicalVolumes DataAndLogFilesOnSeparateLogicalVolumes

Specifies if data and log files are on separate volumes.

Database Database Database

Gets the database that is associated with the AdapterBase object.

(Inherited from DatabaseAdapterBase)
DelayedDurability DelayedDurability DelayedDurability

Gets or sets the delayed durability setting of a database.

(Inherited from DatabaseAdapterBase)
IsSystemObject IsSystemObject IsSystemObject

Gets the Boolean value that specifies whether the adapter base is a system object or not.

(Inherited from DatabaseAdapterBase)
LastBackupDate LastBackupDate LastBackupDate

Gets a Datetime object that indicates the time of the last backup.

(Inherited from DatabaseAdapterBase)
LastLogBackupDate LastLogBackupDate LastLogBackupDate

Gets a Datetime object that indicates the time of the last log backup.

(Inherited from DatabaseAdapterBase)
PageVerify PageVerify PageVerify

Gets a Boolean value that indicates whether the PageVerify setting is set to checksum.

(Inherited from DatabaseAdapterBase)
ReadOnly ReadOnly ReadOnly

Gets or sets a value that indicates whether database is set to read-only.

(Inherited from DatabaseAdapterBase)
RecoveryModel RecoveryModel RecoveryModel

Gets or sets the database adapter recovery model.

(Inherited from DatabaseAdapterBase)
Size Size Size

Gets the database size in megabytes (MB).

(Inherited from DatabaseAdapterBase)
Status Status Status

Gets the database status.

(Inherited from DatabaseAdapterBase)
TargetRecoveryTime TargetRecoveryTime TargetRecoveryTime

Returns target recovery time setting of a database.

(Inherited from DatabaseAdapterBase)
Trustworthy Trustworthy Trustworthy

Gets or sets a value that indicates whether database is set to Trustworthy.

(Inherited from DatabaseAdapterBase)

Methods

Alter() Alter() Alter()

Alters database adapter base properties.

(Inherited from DatabaseAdapterBase)
DataFileVolumeNotIn(List<String>) DataFileVolumeNotIn(List<String>) DataFileVolumeNotIn(List<String>)

Returns a Boolean value that is associated with the database adapter base.

(Inherited from DatabaseAdapterBase)
GetVolume(String) GetVolume(String) GetVolume(String)

Returns the volume name as it appears in the PATH variable.

(Inherited from DatabaseAdapterBase)
Refresh() Refresh() Refresh()

Refreshes all the database objects and properties used by the Database Performance facet.

Applies to