Add checkbox to XEvents to allow for turning on “TRACK_CAUSALITY”
gambit9009 opened this issue · 0 comments
gambit9009 commented
A checked box would just need to add "TRACK_CAUSALITY=ON" at the end of the Create Event Session.
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-event-session-transact-sql?view=sql-server-ver16#track_causality---on--off-
Adds 2 columns to every event, named attach_activity_id.guid and attach_activity_id.seq. Helps in filtering result set.
Need to confirm what versions this started working in and don't turn it on if this...
FIX: TRACK_CAUSALITY causes access violations for batch completed event or RPC completed event in SQL Server 2014 (microsoft.com)