This wait represents SQL Server waiting for non-data page I/O. It is common for this wait to occur during tempdb spill-over from sort and hash operations
DBAs and Developers
- Check to see if tempdb, data and logs are on separate volumes
- Optimize queries experiencing tempdb spillage
Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types
Are I/O latencies killing your performance?