Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

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