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

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
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)
DescriptionSummaryFormatDeltaData source
DB Name
(DB_NAME)
Database name#1COPYstring(257)NoDBCC SQLPERF(LOGSPACE)
Log Size Mbytes
(LOG_SIZE_MB)
Size of space allocated to transaction log (in megabytes) #2AVGdoubleNoDBCC SQLPERF(LOGSPACE)
Log Space Used %
(LOG_SPACE_USED_PCT)
Percentage of transaction log space being used by transaction log#2AVGdoubleNoDBCC SQLPERF(LOGSPACE)
Max Log Space Used %
(MAX_LOG_SPACE_USED_PCT)
Maximum percentage of log space used within an intervalHIdoubleNoDBCC SQLPERF(LOGSPACE)
Max Log Space Used Mbytes
(MAX_LOG_SPACE_USED_MB)
Maximum size of log space used within an interval (in megabytes)HIdoubleNoDBCC SQLPERF(LOGSPACE)
Record Time
(RECORD_TIME)
Interval end time (GMT format) #1COPYtime_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always TLOG) #1COPYchar(8)NoRemote Monitor Collector
Start Time
(START_TIME)
Interval start time (GMT format) #1COPYtime_tNoRemote Monitor Collector
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector