\nIt's easier than you'd think… When you use the SQL Server 2008 CREATE EVENT SESSION DDL statement with extended events, you specify:\n<\/p>\n
\nEvents to be captured (e.g. sqlserver.error_reported)
\nActions to be fired to add more information (e.g. sqlserver.sql_text)
\nPredicates for conditional capture (e.g. where sqlserver.error_reported.error = 547)
\nEvent target to collect the events (e.g. package0.ring_buffer)
\nAddtional options (e.g. MAX_MEMORY)\n<\/p>\n
\nIn general, the way you look for events, actions, predicates, etc to use is to query against the metadata views:\n<\/p>\n
\nselect p.name + '.' + o.name as [Full Name],
\n o.description s [Description]
\nfrom sys.dm_xe_objects o
\njoin sys.dm_xe_packages p on o.package_guid = p.guid
\n— @type can be 'event', 'action', etc
\nwhere o.object_type = @type order by p.name, o.name\n<\/p>\n
\nTwo of the actions listed have to do with activity (causality): package0.attach_activity_id and package0.attach_activity_id_xfer. In addition there is an option TRACE_CAUSALITY. I thought you'd have to set the TRACE_CAUSALITY option and<\/strong> add the actions to collect activity information. But attempting to add either action produced an error.\n<\/p>\n \nIt's easier than that. Simply turning on the TRACE_CAUSALITY option is enough. The actions can't<\/strong> be specified in CREATE EVENT SESSION (or ALTER EVENT SESSION) because they are for internal use. The activity_ids show up at the target without explicitly naming the actions.<\/p>\n","protected":false},"excerpt":{"rendered":" It's easier than you'd think… When you use the SQL Server 2008 CREATE EVENT SESSION DDL statement with extended events, you specify: Events to be captured (e.g. sqlserver.error_reported) Actions to be fired to add more information (e.g. sqlserver.sql_text) Predicates for conditional capture (e.g. where sqlserver.error_reported.error = 547) Event target to collect the events (e.g. package0.ring_buffer) […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,29],"tags":[],"class_list":["post-700","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008"],"yoast_head":"\n