Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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: 934 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