WRITE_COMPLETION
Short Description
Occurs when a write operation is in progress.
Detailed Description​
This wait indicates a synchronous write is being waited on. Can be associated with database snapshots, virtual logfile (VLF) and running DBCC.
How to reduce this wait​
- Reduce the number of snapshots
- Follow general advice for I/O waits only if your I/O subsystem is overloaded.
Additional Links​
- Microsoft Docs - sys.dm_os_wait_stats (Transact-SQL)
- sqlskills.com - WRITE_COMPLETION
- sqlshack.com - WRITE_COMPLETION
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.