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.
Within the data space, the free space can be monitored using Data Unallocate Mbytes and Data Unallocate %. To monitor the usable space, use Data Usable Mbytes and Data Usable %.
The maximum size of the data space including auto-growth can be monitored using Data Max Mbytes, and the remaining size available for auto-growth can be monitored using Data Extensible Mbyte and Data Extensible %.
The maximum size of the log space including auto-growth can be monitored using Log Max Mbytes, and the remaining size available for auto-growth can be monitored using Log Extensible Mbytes and Log Extensible %.
The following figure shows the relationship between fields that collect space data that the database has.
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: 769 bytes
-
Variable part: 357 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
---|---|---|---|---|---|---|
Microsoft SQL Server version 2014 or earlier |
Microsoft 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 Extensible % (PERC_DATA_EXT) |
Remaining size available for auto-growth as a percentage of the data space. If a data file with unlimited auto-growth is included in the database, the value is 100. If any of the following conditions are met, the value is 0.
|
-- |
double |
No |
-- |
sys.database_files.max_size, size |
Data Extensible Mbyte (DATA_EXT_MB) |
Remaining size available for auto-growth of the data space (in megabytes). If any of the following conditions are met, the value is 0.
|
-- |
double |
No |
-- |
sys.database_files.max_size, size |
Data Max Mbytes (DATA_MAX_MB) |
Limit of the data space auto-growth size (in megabytes). If no data files with auto-growth are included in the database, the value is the same as Data Space Mbytes. If a data file with unlimited auto-growth is included in the database, the value is -1. If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
double |
No |
-- |
sys.database_files.max_size, size |
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 |
|
Data Usable % (PERC_DATA_USABLE) |
Total size of the allocated but unused space and the unallocated space as a percentage of the data space. If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
double |
No |
-- |
sys.partitions, sys.allocation_units, sys.internal_tables |
Data Usable Mbytes (DATA_USABLE_MB) |
Total size of the allocated but unused space and the unallocated space of the data space (in megabytes). If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
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 Extensible % (PERC_LOG_EXT) |
Remaining size available for auto-growth as a percentage of the log space. If any of the following conditions are met, the value is 0.
|
-- |
double |
No |
-- |
sys.database_files.max_size, size |
Log Extensible Mbytes (LOG_EXT_MB) |
Remaining size available for auto-growth of the log space (in megabytes). If any of the following conditions are met, the value is 0.
|
-- |
double |
No |
-- |
sys.database_files.max_size, size |
Log Free % (PERC_LOG_FREE) |
Percentage of unused space in the log space that shows the user area. If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
double |
No |
-- |
sys.database_files.max_size, size DBCC SQLPERF (LOGSPACE) |
Log Free Mbytes (LOG_FREE_MB) |
Size of the unused space of the log space that shows the user area.(in megabytes) If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
double |
No |
-- |
sys.database_files.max_size, size DBCC SQLPERF (LOGSPACE) |
Log Max Mbytes (LOG_MAX_MB) |
Limit of the log space auto-growth (in megabytes). If transaction log files with auto-growth are not included in the database, the value is the same as Log Space Mbytes. If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
double |
No |
-- |
sys.database_files.max_size, size |
Log Mbytes (LOG) |
Size of log space being used that shows the user area. (in megabytes) |
-- |
double |
No |
DBCC SQLPERF(LOGSPACE) |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Log Space Mbytes (LOG_SPACE_MB) |
Size of the log space that is allocated to the disk (in megabytes). If the monitored version is Microsoft SQL Server 2014 or earlier, the value is 0. |
-- |
double |
No |
-- |
sys.database_files.max_size, size |
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 |