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.