Description
This wait accumulates while SQL Server is waiting for the operating system to read off a backup. This wait type is not documented by Microsoft so not much is known about it. This wait type does not charge as part of regular disk or tape restores. Pre-emptive waits are different from regular (emptive) waits as their execution is controlled by an external processes such as the operating system
Resolved by
DBAs
Suggested solutions
- Check the SQL Server error log for more information
- Check the Windows Event Viewer for any disk related issues
Additional research
See more
Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device