Server Space Interval (PI_SI)
- Organization of this page
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 |
Over 10 Sec Collection Time |
No |
N |
ODBC key field
None
Lifetime
From the creation until deletion of an instance
Record size
-
Fixed part: 777 bytes
-
Variable part: 0 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
---|---|---|---|---|---|---|
SQL Server version 2014 or earlier |
SQL Server version 2016 or later |
|||||
DB Size (SIZE) |
Size of the entire database (in megabytes)#1 |
COPY |
double |
No |
dbo.sysfiles |
sys.database_files |
Data Mbytes (DATA) |
Size of database being used (in megabytes)#1 |
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#2 |
AVG |
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) |
LO |
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)#1 |
COPY |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
Log Mbytes (LOG) |
Size of log space being used (in megabytes)#1 |
COPY |
double |
No |
DBCC SQLPERF(LOGSPACE) |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format)#1 |
COPY |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always SI)#1 |
COPY |
char(8) |
No |
Agent Collector |
|
Rsvd Mbytes (RESERVED) |
Size of space already allocated (in megabytes)#1 |
COPY |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
Start Time (START_TIME) |
Interval start time (GMT format)#1 |
COPY |
time_t |
No |
Agent Collector |
|
Unused % (PERC_USED) |
Unused space as a percentage of total allocated space#2 |
AVG |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
Unused Mbytes (UNUSED) |
Size of allocated but unused space (in megabytes)#1 |
COPY |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |