IO_COMPLETION Wait

The IO_COMPLETION wait indicates that SQL Server is waiting on something related to IO to finish.  In the event that you are seeing the IO_COMPLETION wait this generally indicates non-data page IO.

Check the placement of your database files.  How is the overall performance of your drives? Is your TempDB on a fast disk, do you have I/O contention on any of your drives?

 

See Also:

Leave a Reply

Your email address will not be published. Required fields are marked *

*

To prove you are not a robot: *