Database Interval (PI_DI)
- Organization of this page
Function
The Database Interval (PI_DI) record indicates interval information, such as the status related to a particular database. One record is created for each database.
This is a multi-instance record.
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 fields
-
PI_DI_DB_NAME
-
PI_DI_DBID
Lifetime
From the creation until deletion of a database
Record size
-
Fixed part: 681 bytes
-
Variable part: 1,398 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 |
|||||
|
Availability (AVAILABILITY) |
Database status. The following values are valid:#1
|
COPY |
string(16) |
No |
master..sysdatabases.status |
sys.databases.state |
|
DB Name (DB_NAME) |
Database name#1 |
COPY |
string(257) |
No |
master..sysdatabases.name |
sys.databases.name |
|
DB Owner (DBO) |
Database owner#1 |
COPY |
string(513) |
No |
User's logon ID for which master..sysdatabases.sid = master..syslogins.sid |
User's logon name for which sys.databases.owner_sid = sys.server_principals.sid |
|
DBID (DBID) |
Database ID#1 |
COPY |
ulong |
No |
master..sysdatabases.dbid |
sys.databases.database_id |
|
Data Growth % (DATA_GROWTH) |
Rate of increase of data space during the interval#2 |
AVG |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
|
Index Growth % (IDX_GROWTH) |
Rate of increase of index space during the interval#2 |
AVG |
double |
No |
sys.partitions, sys.allocation_units, sys.internal_tables |
|
|
Log Growth % (LOG_GROWTH) |
Rate of increase of log space during the interval#2 |
AVG |
double |
No |
DBCC SQLPERF(LOGSPACE) |
|
|
Options (OPTIONS) |
Database options currently specified. Options are delimited by commas. #1 |
COPY |
string(512) |
No |
master..sysdatabases.status, master..sysdatabases.status2 |
sys.databases |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format)#1 |
COPY |
time_t |
No |
Agent Collector |
|
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always DI) #1 |
COPY |
char(8) |
No |
Agent Collector |
|
|
Start Time (START_TIME) |
Interval start time (GMT format) #1 |
COPY |
time_t |
No |
Agent Collector |
|
|
Tran Log Dumps (DUMPED_TRAN) |
Number of transaction log dumps collected during the relevant interval#2 |
AVG |
long |
Yes |
msdb.dbo.backupset |
|
|
Trans/sec (TRAN_SEC) |
Number of transactions per second#2 |
AVG |
double |
Yes |
master..sysperfinfo.transactions/sec |
sys.dm_os_performance_counters.transactions/sec |