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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key field
None
Lifetime
From the creation until deletion of an instance
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
DB Size (SIZE) | Size of the entire database (in megabytes) | COPY | double | No | dbo.sysfiles |
Data Mbytes (DATA) | Size of database being used (in megabytes) | COPY | 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 | AVG | double | No | dbo.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) | LO | double | No | dbo.sysfiles, sys.partitions, sys.allocation_units, sys.internal_tables |
Index Mbytes (IDX) | Size of index space being used (in megabytes) | COPY | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Log Mbytes (LOG) | Size of log space being used (in megabytes) | COPY | double | No | DBCC SQLPERF(LOGSPACE) |
Record Time (RECORD_TIME) | Interval end time (GMT format) | COPY | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always SI) | COPY | char(8) | No | Remote Monitor Collector |
Rsvd Mbytes (RESERVED) | Size of space already allocated (in megabytes) | COPY | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Start Time (START_TIME) | Interval start time (GMT format) | COPY | time_t | No | Remote Monitor Collector |
Unused % (PERC_USED) | Unused space as a percentage of total allocated space | AVG | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
Unused Mbytes (UNUSED) | Size of allocated but unused space (in megabytes) | COPY | double | No | sys.partitions, sys.allocation_units, sys.internal_tables |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |