![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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 |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.