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?
Leave a Reply