IO_COMPLETION

Description

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

Resolved by

DBAs and Developers

Suggested solutions

  1. Check to see if tempdb, data and logs are on separate volumes
  2. Optimize queries experiencing tempdb spillage

Additional research

Causes of IO_COMPLETION and WRITE_COMPLETION SQL Server wait types
Are I/O latencies killing your performance?

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index