Database Space Detail (PD_DS)
Function
The Database Space Detail (PD_DS) record indicates information related to the size of the disk space used by a particular database. One record is created for each database. This is a multi-instance record.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key fields
Lifetime
From the creation until deletion of a database
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
DB Name (DB_NAME) | Database name | -- | string(257) | No | master..sysdatabases.name |
DB Size (SIZE) | Database size (in megabytes) | -- | double | No | dbo.sysfiles |
DBID (DBID) | Database ID | -- | word | No | master..sysdatabases.dbid |
Data Mbytes (DATA) | Size of database being used (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Free % (PERC_FREE) | Free space as a percentage of the size of the entire database, including data files and transaction log files | -- | double | No | dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables |
Free Mbytes (FREE_SPACE) | Size of the free space in the area allocated to the entire database, including data files and transaction log files (in megabytes) | -- | double | No | dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables |
Index Mbytes (IDX) | Size of index space being used (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Log Mbytes (LOG) | Size of log space being used (in megabytes) | -- | double | No | DBCC SQLPERF(LOGSPACE) |
Record Time (RECORD_TIME) | Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always DS) | -- | char(8) | No | Remote Monitor Collector |
Rsvd Mbytes (RESERVED) | Size of space already allocated (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Start Time (START_TIME) | Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Unused % (PERC_USED) | Unused space as a percentage of total allocated space | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Unused Mbytes (UNUSED) | Size of allocated but unused space (in megabytes) | -- | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |