Log write time

Avg log write time (log_writer_task) <duration> ms, <number_of> writes, <number_of> pages

Avg log write time (dev_thread) <duration> ms, <number_of> writes, <number_of> pages

Explanation

The physical writing of log entries takes too long. There is the risk that physical writing of log backups will lead to a bottleneck.

User Response

Check the reads and writes in the disk area or device on which the log volumes are located. If possible, only the log entries should be made here, and no other reads or writes. In certain circumstances, you may need to move the log volumes to a quicker device.

See also:

Concepts of the Database System, Logging Data Changes