Server Space Detail (PD_SS)

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

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key field

None

Lifetime

From the creation until deletion of an instance

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
DB Size
(SIZE)
Size of the entire database (in megabytes)--doubleNosp_databases.db_size
Data Mbytes
(DATA)
Size of the database being used (in megabytes)--doubleNosys.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--doubleNodbo.sysfiles, 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)--doubleNodbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables
Index Mbytes
(IDX)
Size of index space being used (in megabytes)--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
Log Mbytes
(LOG)
Size of log space being used (in megabytes)--doubleNoDBCC SQLPERF(LOGSPACE)
Record Time
(RECORD_TIME)
Interval end time (GMT format)--time_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always SS)--char(8)NoRemote Monitor Collector
Rsvd Mbytes
(RESERVED)
Size of space already allocated (in megabytes)--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
Unused %
(PERC_USED)
Unused space as a percentage of total allocated space--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
Unused Mbytes
(UNUSED)
Size of allocated but unused space (in megabytes)--doubleNosys.partitions, sys.allocation_units, sys.internal_tables
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector