拡張イベントのターゲットのオプションを確認するクエリ

xe_target.sql

select
	xe_p.name as package_name,
	xe_o.name as target_name,
	xe_oc.name as column_name,
	xe_oc.column_type as column_type,
	xe_oc.type_name as type_name,
	xe_oc.description as column_description,
	*
from sys.dm_xe_packages as xe_p
	inner join sys.dm_xe_objects as xe_o
		on xe_p.guid = xe_o.package_guid
	inner join sys.dm_xe_object_columns as xe_oc
		on xe_o.package_guid = xe_oc.object_package_guid and
			xe_o.name = xe_oc.object_name
where
	xe_p.name = N'package0' and
	xe_o.name in (N'ring_buffer', N'event_file') and
	xe_o.object_type = N'target';