DEADLOCK_ENUM_MUTEX

Description

This wait is used internally by SQL Server to stop multiple instances from deadlock monitors at the same time. Small values are expected. If values are excessive investigation is required

Resolved by

DBAs

Suggested solutions

  1. There is a known bug in versions of SQL Server 2005 – 2012 that cause this wait type to be high and lock up the instance. See link below
  2. Examine the SQL Server error log for more information

Additional research

KB972936 Excess DEADLOCK_ENUM_MUTEX waits with ACCESS_VIOLATION

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