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

サポートと今すぐチャット

戻る

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

タイトル

SQL Server outage due to DEADLOCK_ENUM_MUTEX waits from the Diagnostic Server
説明

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.
原因

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
対策

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

フィードバックを送信しました

この記事は課題解決に役立ちましたか?

評価を選択

推奨コンテンツ

製品：: Spotlight on SQL Server Enterprise
12.2, 12.1, 12.0.1, 12.0, 11.7.1, 11.7, 11.6.2, 11.6.1, 11.6, 11.5.1, 11.5, 11.2.1, 11.2, 11.1.1, 11.1, 11.0, 10.5.2, 10.5.1, 10.5, 10.0.2, 10.0.1, 10.0, 9.5.2

タイトル