After an upgrade to a 5.9.4.20 or higher version of the SQL Server cartridge, deadlocks are not detected in the SQL Server Deadlocks Dashboard. The same deadlocks can be viewed in SQL Server Management Studio.
Beginning with the SQL Server cartridge version 5.9.4.20 and higher, we began to use extended events default means to capture deadlock data. Deadlock events are obtained by reading the data collected by the default system_health extended event. Deadlocks will not be captured if user has disabled the system_health session on their instance.
You can check that is it enabled using SQL Server Management Studio
WORKAROUND
Switch the database agent agent status properties (ASP) to use the deadlock collection instead of "Extended Events"
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center