Overview
While using “Object Explorer” within SSMS to look at the extended events sessions defined on your server might be easier, there are catalog views that you can use T-SQL to query and get this information as well.
Explanation
Below is a list of each of these views, along with a short description of their contents.
- sys.server_event_sessions – lists all the event sessions defined on the server
- sys.server_event_session_events – contains a row for each event defined for each event session
- sys.server_event_session_actions – contains a row for each action of each event defined for each event session
- sys.server_event_session_fields – contains a row for each customizable column that was set explicitly on an event or target
- sys.server_event_session_targets – contains a row for each target defined for each event session
Additional Information
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