Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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

Overview

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.

 

 

Environment

DPA 10.2 and later

Resolution

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

Tags

Classifications

Public