Submit a ticketCall us
Home > Success Center > Database Performance Analyzer (DPA) > DPA deadlock collection not enabled by default

DPA deadlock collection not enabled by default

Updated January 26, 2018

Overview

Note: This feature is currently available for SQL Server 2012 and later. If you are monitoring an earlier version of SQL Server or another type of database (Oracle, for example), DPA does not display the Deadlocks tab.

 

When you are monitoring a SQL Server 2012 or later database instance, DPA has the ability to collect and monitor information about deadlocks. Deadlock collection is not enabled by default because it uses Extended Event Session (EES). Historically, the EES was known for bugs and glitches, so we wanted to allow the user to decide when and where to enable deadlock collection. When deadlock collection is enabled, DPA will configure your SQL Server instance with a low level extended event session to capture occurrences of deadlocks.

Environment

DPA 10.2 and later

Resolution

You can enable deadlock collection in Advanced Options, or from the UI. It can be enabled for a specific database instance or for all supported database instances.

From the UI

  1. From the DPA home page, click a SQL Server database instance to view details.
  2. On the lower half of the screen, click the Deadlocks tab.
    If deadlock collection is not enabled, the following button is displayed.
    EnableDeadlocks.png
  3. Click Enable Deadlock Collection.
    A dialog displays information about the deadlock collection feature.
  4. Click one of the following:
    • Enable for THIS monitor enables deadlock collection only for this SQL Server database instance.
    • Enable for ALL monitors  enables deadlock collection for all supported SQL Server database instances.

From Advanced Options

  1. From the DPA home page, go to Options > Administration tab > Advanced Options.
  2. If you want to enable it for a specific database instance, click DB Instance Options and select the instance. To enable it for all supported SQL Server database instances, stay on the System Options tab.
  3. Click the Support Options box and find DEADLOCK_POLL_ENABLED.
  4. Change the value to True.

 

Last modified

Tags

Classifications

Public