IO / Logging Performance
Purpose
Logging performance view shows the performance of transaction logging.
Screenshot
Metric shown
Member
The identifier for the database member from which the data was retrieved for this result record.
Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).MEMBER
Actual log writes / Delta log writes/s
The number of I/O requests issued by the logger for writing log data to the disk.
Source: MON_GET_TRANSACTION_LOG(#MEMBER#).SUM(NUM_LOG_WRITE_IO)
Average log Writes times
The average elapsed time spent by the logger writing log data to the disk.
= LOG_WRITE_TIME / NUM_LOG_WRITE_IO
Source:
LOG_WRITE_TIME = MON_GET_TRANSACTION_LOG(#MEMBER#).AVG(LOG_WRITE_TIME)
NUM_LOG_WRITE_IO = MON_GET_TRANSACTION_LOG(#MEMBER#).SUM(NUM_LOG_WRITE_IO)
Actual log reads / Delta log reads/s
The number of I/O requests issued by the logger for reading log data from the disk.
Source: MON_GET_TRANSACTION_LOG(#MEMBER#).SUM(NUM_LOG_READ_IO)
Average log reads times
The average elapsed time spent by the logger reading log data from the disk.
= LOG_READ_TIME / NUM_LOG_READ_IO
Source:
LOG_READ_TIME = MON_GET_TRANSACTION_LOG(#MEMBER#).AVG(LOG_READ_TIME)
NUM_LOG_READ_IO = MON_GET_TRANSACTION_LOG(#MEMBER#).SUM(NUM_LOG_READ_IO)
Actual logFullEvents / Delta logFullEvents/s
The number of times agents have to wait for log data to write to disk while copying log records into the log buffer.
Source: MON_GET_TRANSACTION_LOG(#MEMBER#).SUM(NUM_LOG_BUFFER_FULL)
Actual commits / Delta commits/s
The total number of commit statements issued by the client application.
Source: MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_APP_COMMITS)
Actual activities/commits
The average number of coordinator activities at any nesting level that completed successfully per commit.
= ACT_COMPLETED_TOTAL / TOTAL_APP_COMMITS
Source:
ACT_COMPLETED_TOTAL = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(ACT_COMPLETED_TOTAL)
TOTAL_APP_COMMITS = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_APP_COMMITS)
Average commits times
The average amount of time spent performing commit processing on the database server per commit.
= TOTAL_COMMIT_TIME / TOTAL_APP_COMMITS
Source:
TOTAL_COMMIT_TIME = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_COMMIT_TIME)
TOTAL_APP_COMMITS = MON_GET_SERVICE_SUBCLASS(NULL, NULL, #MEMBER#).SUM(TOTAL_APP_COMMITS)