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: *