Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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