Show TOC

Log Write TimeLocate this document in the navigation structure

Use

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 of a bottleneck.

User Response

Check the read and write operations 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 read or write operations. In certain circumstances, you may need to move the log volumes to a quicker device.

More Information

Concepts of the Database System, How Databases Log Data Changes