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.

Leave a Reply

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


To prove you are not a robot: *