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!
SteveStedman5
SteveStedman5
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!

Contact Info

Stedman Solutions, LLC.
PO Box 3175
Ferndale WA 98248

Phone: (360)610-7833

Leave a Reply

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

*

To prove you are not a robot: *