SQL Server outage due to DEADLOCK_ENUM_MUTEX waits from the Diagnostic Server (4335459)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Server outage due to DEADLOCK_ENUM_MUTEX waits from the Diagnostic Server
Description

SQL Server is down (or fails over in a cluster environment) due to blocking/performance issues from Diagnostic Server sessions with the DEADLOCK_ENUM_MUTEX wait type.
Cause

The issue is not on the Spotlight side but on SQL Server and described by Micorsoft KB972936. It mentions a crash from a query to sys.dm_os_waiting_tasks which Spotlight do use. The queries are located here in C:\Program Files\Quest Software\Diagnostic Server\Agent\conf\Package\sqlserver_spotlight\2005.
- QS_TempDBContention.sql
- TempDBPageWaitTimes.sql
Resolution

As the issue pertains to SQL Server please refer to Microsoft directly. The links below are meant as reference:
1. https://support.microsoft.com/en-us/kb/972936
2. http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9504496d-50ee-400d-897d-d47e7c6effa7/undetected-deadlocks

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title