Overview
There are a couple of ways you can delete an extended events session, which we will show below.
Explanation
Delete Extended Events Session Using T-SQL
To remove an extended events session using T-SQL, we can use the “DROP EVENT SESSION” statement. This statement takes only the session name as input, as shown below.
DROP EVENT SESSION [First_XEvent_Session] ON SERVER;
Delete Extended Events Session Using SSMS
You can also remove a session using “Object Explorer” by expanding the “Management” node, then “Extended Events,” then “Sessions.” You can then right-click on the event you want to remove and select “Delete” to drop the session, as shown below.
Additional Information
- Check out these other Extended Events articles
- Steps to Recover the system_health Extended Events Session in SQL Server
Ben Snaidero has been a Database Administrator for just over 10 years. Starting out working mainly with Oracle he got into SQL Server in 2005 and has worked primarily with SQL Server for the last 3 years. His main focus with both Oracle and SQL Server is in the area of performance tuning.
- MSSQLTips Awards: Achiever (75+ tips) – 2018 | Author of the Year Contender – 2016-2017