Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 95 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
14:08, 1 Jul 2016

Tags

Classifications

Public