PREEMPTIVE_OS_DEVICEOPS

Description

This wait accumulates while SQL Server is waiting for device operations to complete. Not much is known about this wait type as it is not documented by Microsoft. Values in this wait type are most common on instances using snapshot backups. Small values do not appear to cause any issues. 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

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

Additional research

Should I Be Using SAN Snapshots as a Backup Solution?

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