Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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

Tags

Classifications

Public