Database Space Detail (PD_DS)

Organization of this page

Function
Default and changeable values
ODBC key fields
Lifetime
Record size
Fields

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.

[Figure]

To Page Top

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

To Page Top

ODBC key fields

PD_DS_DB_NAME
PD_DS_DBID

To Page Top

Lifetime

From the creation until deletion of a database

To Page Top

Record size

Fixed part: 769 bytes
Variable part: 357 bytes

To Page Top

Fields

View name (Manager name)	Description	Summary	Format	Delta	Data source
View name (Manager name)	Description	Summary	Format	Delta	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. Data files with auto-growth are not included in the database. The auto-growth size has reached its limit. The monitored version is Microsoft SQL Server 2014 or earlier.	--	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. Data file with unlimited auto-growth is included in the database. Data files with auto-growth are not included in the database. The auto-growth size has reached its limit. The monitored version is Microsoft SQL Server 2014 or earlier.	--	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. Transaction log files with auto-growth are not included in the database. The auto-growth size has reached its limit. The monitored version is Microsoft SQL Server 2014 or earlier.	--	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. Transaction log files with auto-growth are not included in the database. The auto-growth size has reached its limit. The monitored version is Microsoft SQL Server 2014 or earlier.	--	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

To Page Top