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

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

Lifetime

From the creation until deletion of a database

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
DB Name
(DB_NAME)
Database name--string(257)Nomaster..sysdatabases.name
DB Size
(SIZE)
Database size (in megabytes)--doubleNodbo.sysfiles
DBID
(DBID)
Database ID--wordNomaster..sysdatabases.dbid
Data Mbytes
(DATA)
Size of database being used (in megabytes)--doubleNosys.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--doubleNodbo.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)--doubleNodbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables
Index Mbytes
(IDX)
Size of index space being used (in megabytes)--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
Log Mbytes
(LOG)
Size of log space being used (in megabytes)--doubleNoDBCC SQLPERF(LOGSPACE)
Record Time
(RECORD_TIME)
Interval end time (GMT format)--time_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always DS)--char(8)NoRemote Monitor Collector
Rsvd Mbytes
(RESERVED)
Size of space already allocated (in megabytes)--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
Unused %
(PERC_USED)
Unused space as a percentage of total allocated space--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
Unused Mbytes
(UNUSED)
Size of allocated but unused space (in megabytes)--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector