September 14, 2017 at 12:14 am
Comments posted to this topic are about the item Extended Events Parity with Trace
September 14, 2017 at 1:48 am
Took a complete guess and got it wrong.
September 14, 2017 at 6:48 am
Interesting question, thanks Steve
Thought this came out with 2014, so learned something interesting...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
September 14, 2017 at 7:42 am
Stewart "Arturius" Campbell - Thursday, September 14, 2017 6:48 AMInteresting question, thanks Steve
Thought this came out with 2014, so learned something interesting...
If you run the query in the MS docs from this page
View the Extended Events Equivalents to SQL Trace Event Classes
This doc says a couple of times:
If all columns return NULL except for the Event Class column, this indicates that the event class was not migrated from SQL Trace.
I get interesting results on a 2014 instance and nulls in this regard.
Edit: to be more less obvious.
September 17, 2017 at 5:17 pm
Great question. I remember looking into EE on SQL 2008. I let it run for 20 minutes and turned it off. I then tried to read in the file I had created. After 40 minutes, I gave up and determined that it wasn't performant enough to be used. A friend told me that it works much better in SQL 2012 and later, so maybe I'll give it another look.
Thanks for the question. Your timing couldn't be better, as I'm looking at ways to implement auditing on SE. I know I'll be reading that stairway series.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply