Databases

Databases

All DBs - Columns

Name	Description
Inst ID	Instance ID; 0 = non-CE
Database Name	Database name
Size	Total allocated size of the database (data + log)
Data Space % Used	% of total allocated size, for data, that is used
Log Space % Used	% of total allocated size, for log, that is used
Log Suspend	Whether the transaction log is full for the database
Last Checkpoint	Time of the last checkpoint on the database
Dumpable	0 = Normal transaction log dump is allowed; >0 = Not dumpable due to some issue (see ASE docs for further interpretation); -1 = Unavailable dumpable status
Last Txn Log Dump	Time of last transaction log dump initiated by user
Shrink Status	Yes = Database shrink in progress; No = No shrink in progress; unknown = Unknown shrink status
Encryption Status	Encryption status: normal encrypted being encrypted partially encrypted being decrypted partially decrypted unknown
Options Set	Database options; no options set = No database options set; otherwise, one or more options, including (but not limited to): abort tran on log full allow nulls by default archive async log service auto identity compressed data compressed log dbo use only ddl in tran delayed commit don't recover erase residual data failed upgrade has suspect pages/objects identity in nonunique index mixed log and data no chkpt on recovery no free space acctg not recovered offline online for standby access quiesce database read only scratch select into/bulkcopy/pllsort single user trunc log on chkpt unique auto_identity index user created temp db
Owner	Database owner name
Date Created	Time of database creation
Hours Since Checkpoint	Number of hours since the last checkpoint on the database
Hours Since Dump	Number of hours since internal last transaction log dump time
Recover Order	Recovery order #; set by sp_dbrecovery_order()
Int Txn Dump	Internal last transaction log dump time; includes frequent system-initiated transaction log dumps

Temp DBs - Columns

Name	Description
Inst ID	Instance ID; 0 = non-CE
Database Name	Database name
Size	Total allocated size of the database (data + log)
Data Space % Used	% of total allocated size, for data, that is used
Log Space % Used	% of total allocated size, for log, that is used
Log Suspend	Whether the transaction log is full for the database
Last Checkpoint	Time of the last checkpoint on the database
Dumpable	0 = Normal transaction log dump is allowed; >0 = Not dumpable due to some issue (see ASE docs for further interpretation); -1 = Unavailable dumpable status
Last Txn Log Dump	Time of last transaction log dump initiated by user
Shrink Status	Yes = Database shrink in progress; No = No shrink in progress; unknown = Unknown shrink status
Encryption Status	Encryption status: normal encrypted being encrypted partially encrypted being decrypted partially decrypted unknown
Options Set	Database options; no options set = No database options set; otherwise, one or more options, including (but not limited to): abort tran on log full allow nulls by default archive async log service auto identity compressed data compressed log dbo use only ddl in tran delayed commit don't recover erase residual data failed upgrade has suspect pages/objects identity in nonunique index mixed log and data no chkpt on recovery no free space acctg not recovered offline online for standby access quiesce database read only scratch select into/bulkcopy/pllsort single user trunc log on chkpt unique auto_identity index user created temp db
Owner	Database owner name
Date Created	Time of database creation
Hours Since Checkpoint	Number of hours since the last checkpoint on the database
Hours Since Dump	Number of hours since internal last transaction log dump time
Recover Order	Recovery order #; set by sp_dbrecovery_order()
Int Txn Dump	Internal last transaction log dump time; includes frequent system-initiated transaction log dumps

Index Stats - Columns

Name	Description
Owner	Name of owner of table
Table	Table name
Index	Index name
Index ID	ID of index
Row Count	Number of rows
Reserved	Total allocated size
Data Page Cluster Ratio	Data Page Cluster Ratio
Index Page Cluster Ratio	Index Page Cluster Ratio
Data Row Cluster Ratio	Data Row Cluster Ratio
Large IO Efficiency	Large IO Efficiency
Space Utilization	Space Utilization
Index Space % Free	% space free
Index Space Usage	Unused space + Amount of space used
Type	Type of object

Entity Requirements

Attributes:	MDA
Minimum database version:	15.0.3