Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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

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