Transaction Log Overview (PI_TLOG)
Function
The Transaction Log Overview (PI_TLOG) record indicates information related to transaction log space. One record is created for each database transaction log. 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 |
ODBC key field
PI_TLOG_DB_NAME
Lifetime
From the creation until deletion of a database
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
DB Name (DB_NAME) | Database name#1 | COPY | string(257) | No | DBCC SQLPERF(LOGSPACE) |
Log Size Mbytes (LOG_SIZE_MB) | Size of space allocated to transaction log (in megabytes) #2 | AVG | double | No | DBCC SQLPERF(LOGSPACE) |
Log Space Used % (LOG_SPACE_USED_PCT) | Percentage of transaction log space being used by transaction log#2 | AVG | double | No | DBCC SQLPERF(LOGSPACE) |
Max Log Space Used % (MAX_LOG_SPACE_USED_PCT) | Maximum percentage of log space used within an interval | HI | double | No | DBCC SQLPERF(LOGSPACE) |
Max Log Space Used Mbytes (MAX_LOG_SPACE_USED_MB) | Maximum size of log space used within an interval (in megabytes) | HI | double | No | DBCC SQLPERF(LOGSPACE) |
Record Time (RECORD_TIME) | Interval end time (GMT format) #1 | COPY | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always TLOG) #1 | COPY | char(8) | No | Remote Monitor Collector |
Start Time (START_TIME) | Interval start time (GMT format) #1 | COPY | time_t | No | Remote Monitor Collector |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |