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 |
|