Skip to main content

WRITELOG

Short Description

Occurs while waiting for a log flush to complete. Common operations that cause log flushes are checkpoints and transaction commits.

Detailed Description​

It is common to see these waits on your system as the log will be written when:

  • A thread issues a commit
  • A log block fills during a transaction
  • Page updates force a log block to be written

How to reduce this wait​

  • Batch commits
  • Cut down the amount of pages changed
  • Consider your physical design, isolating transaction logs and using fast or solid state disk this purpose
  • Consider using DELAYED_DURABILITY for your transactions if you are at SQL 2014 or later, but be aware of the risks of data loss in the case of server crash or power outage.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.