Description

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

DBAs

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

⇐ Back to index