DatabasePerformanceAdapter Class

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

System.Object
  Microsoft.SqlServer.Management.Smo.DatabaseAdapterBase
    Microsoft.SqlServer.Management.Smo.DatabasePerformanceAdapter

No code example is currently available or this language may not be supported.

NameDescription
System_CAPS_pubmethodDatabasePerformanceAdapter(Database)

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

NameDescription
System_CAPS_pubpropertyAutoClose

Gets or sets a value that indicates whether the AutoClose is on.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyAutoShrink

Gets or sets a value that indicates whether the AutoShrink is on.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyCollationMatchesModelOrMaster

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

System_CAPS_pubpropertyDataAndLogFilesOnSeparateLogicalVolumes

Specifies if data and log files are on separate volumes.

System_CAPS_protpropertyDatabase

Gets the database that is associated with the AdapterBase object.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyDelayedDurability

Gets or sets the delayed durability setting of a database.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean value that specifies whether the adapter base is a system object or not.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyLastBackupDate

Gets a Datetime object that indicates the time of the last backup.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyLastLogBackupDate

Gets a Datetime object that indicates the time of the last log backup.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyPageVerify

Gets a Boolean value that indicates whether the PageVerify setting is set to checksum.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyReadOnly

Gets or sets a value that indicates whether database is set to read-only.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyRecoveryModel

Gets or sets the database adapter recovery model.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertySize

Gets the database size in megabytes (MB).(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyStatus

Gets the database status.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyTargetRecoveryTime

Returns target recovery time setting of a database.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubpropertyTrustworthy

Gets or sets a value that indicates whether database is set to Trustworthy.(Inherited from DatabaseAdapterBase.)

NameDescription
System_CAPS_pubmethodAlter()

Alters database adapter base properties.(Inherited from DatabaseAdapterBase.)

System_CAPS_protmethodDataFileVolumeNotIn(List<String>)

Returns a Boolean value that is associated with the database adapter base.(Inherited from DatabaseAdapterBase.)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFinalize()

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodGetVolume(String)

Returns the volume name as it appears in the PATH variable.(Inherited from DatabaseAdapterBase.)

System_CAPS_protmethodMemberwiseClone()

(Inherited from Object.)

System_CAPS_pubmethodRefresh()

Refreshes all the database objects and properties used by the Database Performance facet.(Overrides DatabaseAdapterBase.Refresh().)

System_CAPS_pubmethodToString()

(Inherited from Object.)

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show: