Select Page

WRITELOG Wait

The WRITELOG Wait generally indicates that some task is waiting on the contents of the SQL Server transaction log to be written from memory to disk.  This write occurs when a transaction is committed.

Fixing the problem

  • Increase I/O on the disk subsystem where the transaction log is being written.
  • Sometimes reducing the size of the transaction log helps.
  • Sometimes committing too often on a large batch can cause this.  Look for batches with too many commits.

Submit a Comment

Your email address will not be published. Required fields are marked *

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.