Log write

Number of records being submitted to the internal logging component of the server per second.

Correlate this counter with the Log file write counter to determine whether writing the log records to disk is keeping up with the number of records in the Log write counter.

Log file write

Actual number of blocks written to disk per second by the logger.

The timing of the block writes is dependent on the Logging.DurabilityLevel parameter setting.

If the value of the Log file write counter remains constant, it is a sign of healthy logging. A decrease in the values might indicate that logging is becoming disk bound.

Log file write bytes

Number of log block writes in bytes before log file is flushed

Log nocp write

Number of pending log records since the last checkpoint. This counter gives an indication of how large and involved the next checkpoint operation will be. If the value is consistently large, you might need to increase the frequency of checkpointing.

Log size

Total size of log file, in KB

Log flush (L)

Logical log flushes/sec (for example, commit)

Log flush (P)

Physical log flushes/sec

Log grpcommwkup

Group commit wakeups/sec

Log flush full

Log page full flushes/sec

Log wait flush

Current number of user threads waiting for log operation

Log writeq full rec

Log writes while log write queue full (in number of records)

Log writeq full byt (byte size)

Log writes while log write queue full (in bytes)

Log writeq records

Number of records in current log writer queue.

Log writeq bytes

Number of bytes in log writer queue.

Log writeq pending bytes

Number of bytes for the next log writer queue flush.

Log availq items

Number of records added to available items queue

Log writeq add

Number of records added to log writer queue.

Log writeq write

Number of records written from log writer queue to log file.

Log writeq items allocated count

Number of write queue items in the system

Log writeq bytes allocated count

Amount of memory in bytes allocated for write queue items in the system

Log writeq items freed

Internal use only.

Log writeq items blocking waits

Internal use only.

Log writeq items only distribute

Internal use only.

Log writeq remove abort stmt

Number of aborted statements removed from the log queue

Log writeq remove abort trx

Number of aborted transactions removed from the log queue

Log grpcommits

Number of transactions in the most recent group commit

Transaction commits are grouped in one log burst which is written to the log file in a single write.

Log grpcommits (phase2)

Number of HotStandby phase 2 transactions in the most recent group commit.

Note: You can use this counter only in HotStandby setups.

Log before image

Update row before image log writes/sec. When HSB or Logreader is enabled a before image of an updated row is written to a log file. The counter tells how many of those before images are written to a log file.