Server Space Interval (PI_SI)

Function

The Server Space Interval (PI_SI) record indicates interval 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)COPYdoubleNodbo.sysfiles
Data Mbytes
(DATA)
Size of database being used (in megabytes)COPYdoubleNosys.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 filesAVGdoubleNodbo.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)LOdoubleNodbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables
Index Mbytes
(IDX)
Size of index space being used (in megabytes)COPYdoubleNosys.partitions, sys.allocation_units, sys.internal_tables
Log Mbytes
(LOG)
Size of log space being used (in megabytes)COPYdoubleNoDBCC SQLPERF(LOGSPACE)
Record Time
(RECORD_TIME)
Interval end time (GMT format)COPYtime_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always SI)COPYchar(8)NoRemote Monitor Collector
Rsvd Mbytes
(RESERVED)
Size of space already allocated (in megabytes)COPYdoubleNosys.partitions, sys.allocation_units, sys.internal_tables
Start Time
(START_TIME)
Interval start time (GMT format)COPYtime_tNoRemote Monitor Collector
Unused %
(PERC_USED)
Unused space as a percentage of total allocated spaceAVGdoubleNosys.partitions, sys.allocation_units, sys.internal_tables
Unused Mbytes
(UNUSED)
Size of allocated but unused space (in megabytes)COPYdoubleNosys.partitions, sys.allocation_units, sys.internal_tables
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector