SQL Server Extended Events

Posted by John Liu on Wednesday, March 1, 2023

Following query provides the name mapping between trace and extended events. Not all event classes have equivalent Extended Events events.

SELECT te.name
	,xe.package_name
	,xe.xe_event_name
FROM
	sys.trace_events AS te
	LEFT JOIN
		sys.trace_xe_event_map AS xe
			ON
				te.trace_event_id = xe.trace_event_id
WHERE xe.trace_event_id IS NOT NULL