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

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index