The extended events seem like a better technology and less stress on the server, but the SQL Profiler/perfmon has better tooling. Also the extended events seem to have a steeper learning curve. In which context should each be used? Is it worth getting past the steep learning curve to take advantage of the extended events?

  • 3
    I'm no expert on Xevents, but from what I have seen they are better at asking specific questions of things that are or just happened. I still heavily use perfmon for regular monitoring and general server health as well as establishing baselines. I also use it for extended data collection that I can analyze later. I'm definatley marking this as a fav question though because I'd love to learn more about the potential of Xevents. – RThomas May 12 '11 at 3:23
  • @Michael Hedgpeth - Please be specific and restrict your post to one or two question. Too many questions in one post make it difficult to answer and will end up open ended and subjective post. – CoderHawk May 12 '11 at 6:18
  • @Sandy I considered leaving the question section blank. I really do have a simple question: when should I use one over the other? I was expecting answers like: always, never, when you face X situation. Should I remove the body of the question? – Michael Hedgpeth May 12 '11 at 10:23
  • @Michael Hedgpeth - I understood your intention; let me explain bit more... "always" and "never" answers will be personal preference of each people (i.e. it will be subjective). – CoderHawk May 12 '11 at 11:39
  • @Michael Hedgpeth - "when you face X situation" - that will end up as a discussion. It is indeed a good question. Lets see everyones response... – CoderHawk May 12 '11 at 11:42

Is it worth getting past the steep learning curve to take advantage of the extended events?

Definitely yes. Extended Events is a new platform with better performance, scalability than SQL Trace and the functionality that is in SQL Server 2008 is kind of limited when compared to SQL Trace and also there is some learning curve. Rest assured, Extended Events is getting a major over haul in SQL Server DENALI and there will be lot of options & use cases available in Extended Events that won't be in SQL Trace. Extended Events is the future of monitoring & troubleshooting going forward and some day in the future SQL Trace will be removed.

Note that MSFT won't deprecate a feature right away when a new platform is introduced. Extended Events is in Version 1 (SQL Server 2008) and there are lot of things that need to be improved, modified before removing SQL Trace which was there in the product for a long time.

To get over the learning curve, practice examples from blog posts written by Jonathan Kehayias and few of mine too (shameless plug).



To Sandy: a I don't think Michael has asked too many different questions on various topics in this thread. Yes there are many questions but they are on the same topic. I don't think he should open up several threads to split this one.

  • how can we use this in sql server 2016 web edition to analyze data and tune in tuning advisor? – MonsterMMORPG Jun 29 '16 at 19:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.