Description
This wait accumulates while SQL Server is waiting for the operating system to return the available disk space on a volume. This typically occurs when a user runs xp_fixeddrives or accesses the sys.dm_os_volume_stats management view. Some values in this wait type are expected but if values are high see the suggested solutions below. 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
- Examine wait statistics on the instance. Investigate accordingly