Transaction Log Overview (PI_TLOG)
- Organization of this page
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 |
Over 10 Sec Collection Time |
No |
N |
ODBC key field
PI_TLOG_DB_NAME
Lifetime
From the creation until deletion of a database
Record size
-
Fixed part: 681 bytes
-
Variable part: 313 bytes
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 allocated 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 |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record type (always TLOG) #1 |
COPY |
char(8) |
No |
Agent Collector |
Start Time (START_TIME) |
Interval start time (GMT format) #1 |
COPY |
time_t |
No |
Agent Collector |