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


Suggested solutions

  1. Check the SQL Server error log for more information
  2. Check the Windows Event Viewer for any disk related issues
  3. Examine wait statistics on the instance. Investigate accordingly

Additional research


See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index