Server Space Detail (PD_SS)
- Organization of this page
Function
The Server Space Detail (PD_SS) record indicates information related to the size of the disk space used by Microsoft SQL Server. One record is created for each Microsoft SQL Server instance.
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 field
None
Lifetime
From the creation until deletion of an instance
Record size
-
Fixed part: 753 bytes
-
Variable part: 0 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 Size (SIZE) |
Size of the entire database (in megabytes) |
-- |
double |
No |
sp_databases.db_size |
sys.database_files |
Data Mbytes (DATA) |
Size of the 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 |
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 that shows the user area. (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 SS) |
-- |
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 |