ASYNC_IO_COMPLETION Wait
ASYNC_IO_COMPLETION Wait This wait type is triggered when SQL Server is performing an asynchronous I/O operation and is waiting for the operation to complete. I/O operations are processes that involve transferring data to or from a storage device, such as …