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:
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Download this page in PDF format
Leave a Reply