As part of SQL Server’s regular functionality it periodically searches for deadlocks. This wait type accumulates between deadlock detections. As this is an idling wait it is safe to ignore. It does not indicate deadlocks are occurring

Resolved by


Suggested solutions

  1. High values are safe to ignore
  2. If there is concern over deadlocks check the Windows Performance Log counter Number of Deadlocks/sec, the SQL Server error log or configure a trace/Profiler or Extended Event session

Additional research

Filtering Out Benign Waits
Accidential DBA: Troubleshooting Deadlocks

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