Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > Deadlocks tab not showing in DPA 10.2

Deadlocks tab not showing in DPA 10.2

Updated August 12, 2016


Note: This feature is currently only available for SQL Server 2012 and above.


After upgrading to DPA v10.2, the deadlocks tab does not show up.

DPA disables deadlocks by default for the SQL server because it is using extended events. To use the feature, DPA will need to run code on your SQL server to set up a low level extended event trace.
The feature is using Extended Event Session (EES) mechanism for collecting deadlock data on the SQL side.

The EES is notoriously known for bugs and glitches, some of them are capable of bringing the SQL server down. This is the reason why there is a need to enable the deadlock polling feature at first.




DPA 10.2 and later


To enable Deadlock feature:

  1. From the DPA home screen, go to Options > Administration tab > Advanced Options.
  2. Click the Support Options box and find DEADLOCK_POLL_ENABLED.
  3. Change the value to True.


Last modified
15:29, 9 Sep 2016