WRITE_COMPLETION

Description

Similar to IO_COMPLETION, except this counter is present more for instances using database snapshots and performing some transaction log operations

Resolved by

DBAs and Developers

Suggested solutions

  1. Decrease number of database snapshots (if applicable)
  2. Clean up transaction log internal fragmentation (decrease number of VLFs to a suitable amount)

Additional research

Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types
High Virtual Log File (VLF) Count

⇐ Back to index