Database Space Detail (PD_DS)
- Organization of this page
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.
The free space in the database (data space and log space) can be monitored using the Free Mbytes and Free % views.
The free space in the data space can be monitored using Data Unallocate Mbytes and Data Unallocate % views.
The following figure shows the relationship between fields that collect space data that the database has.
![[Figure]](GRAPHICS/ZUQ05003.GIF)
Default and changeable values
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
60 |
Y |
|
Collection Offset |
0 |
Y |
|
Log |
No |
Y |
|
LOGIF |
(Blank) |
Y |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PD_DS_DB_NAME
-
PD_DS_DBID
Lifetime
From the creation until deletion of a database
Record size
-
Fixed part: 681 bytes
-
Variable part: 357 bytes
Fields
|
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
|---|---|---|---|---|---|---|
|
SQL Server version 2014 or earlier |
SQL Server version 2016 or later |
|||||
|
DB Name (DB_NAME) |
Database name |
-- |
string(257) |
No |
master..sysdatabases.name |
sys.databases.name |
|
DB Size (SIZE) |
Database size (in megabytes) |
-- |
double |
No |
dbo.sysfiles |
sys.database_files |
|
DBID (DBID) |
Database ID |
-- |
ulong |
No |
master..sysdatabases.dbid |
sys.databases.database_id |
|
Data Mbytes (DATA) |
Size of data space being used (in megabytes) |
-- |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
|
Data Space Mbytes (DATA_SPACE_MB) |
Size of the data space (in megabytes) |
-- |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
|
Data Unallocate Mbytes (DATA_UNALLOCATE_MB) |
Size of the free space in the data space (in megabytes) |
-- |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
|
Data Unallocate % (DATA_UNALLOCATE_RATIO) |
Free space as a percentage of the data space |
-- |
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 |
sys.database_files, 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 |
sys.database_files, 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 |
Agent Collector |
|
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always DS) |
-- |
char(8) |
No |
Agent 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 |
Agent 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 |
|