Submit a ticketCall us
Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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: 1,025 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