Provides state and statistical information pertaining to databases that are currently in use. Requires the enable monitoring configuration parameter to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
DBID |
int |
Unique identifier for the database |
|
BackupStartTime |
datetime |
Date that the last backup started for the database |
|
BackupInProgress |
int |
Whether a backup is currently in progress for the database |
|
LastBackupFailed |
int |
Whether the last backup of the database failed |
|
TransactionLogFull |
int |
Whether the database transaction log is full |
|
AppendLogRequests |
int |
counter |
Number of semaphore requests when attempting to append to the database transaction log |
AppendLogWaits |
int |
counter |
Number of times a task had to wait for the append log semaphore to be granted |
DatabaseName |
varchar(30) |
null |
Name of the database |
