Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Remove the SQL Server Extended Events Session created by DPA

Remove the SQL Server Extended Events Session created by DPA

Table of contents
Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Jul 01, 2016

Views: 212 Votes: 0 Revisions: 1

July 5, 2016

Overview

DPA uses the SQL Server Extended Events Session to collect information about deadlocks that occurred in the database. By default, DPA creates its own Extended Events Session named dpa_deadlock_capture.

If you experience a problem with the Extended Events Session on the SQL Server database instance and you disable deadlock polling, DPA does not remove the session.

Note: If you unregister the database instance and select the Remove the DPA Database Objects from the Database Instance option, the Extended Events Session will be deleted.

Environment

  • DPA 10.2 and later

Detail

To manually delete the Extended Events Session created by DPA, execute the following query on the SQL Server database instance:

DROP EVENT SESSION dpa_deadlock_capture
ON SERVER

 

 

 

 

Last modified

Tags

Classifications

Public