Extended Events Targets

Question

Extended Events Targets

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
November 21, 2015 at 12:11 pm

#100916

Comments posted to this topic are about the item Extended Events Targets
November 22, 2015 at 11:30 pm

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287024 More actions · Answer 1

Stewart "Arturius" Campbell (11/22/2015)
Really interesting question, thanks Steve.
Heven't used extended events yet, so learned something new.

I haven't used them in production either. I played with them once, but found that trying to query the results was so slow that it wasn't performant enough to be used.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

SQL_Hunt

SSC-Dedicated

Points: 33518

November 23, 2015 at 9:07 am

#1841763

Nice Easy question. Thanks Steve

Thanks.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

Stewart "Arturius" Campbell (11/22/2015)
Really interesting question, thanks Steve.
Heven't used extended events yet, so learned something new.

Same here.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Ed Wagner (11/23/2015)
Stewart "Arturius" Campbell (11/22/2015)
Really interesting question, thanks Steve.
Heven't used extended events yet, so learned something new.
I haven't used them in production either. I played with them once, but found that trying to query the results was so slow that it wasn't performant enough to be used.

The initial xml query is slow. But that is if translating the xml on the fly. Staging it is many times faster and definitely very useful.

Here is an entire series showing many ins and outs on XEvents (including how to make data queries faster).

http://bit.ly/XE60Days

There is even an article showing the event counter target and the xml structure of that target.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

If you haven't used XEvents yet, I want to know what it is that is holding you back so far. It would make good material for more articles on XEvents.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events