Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
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. –  Coder Hawk 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). –  Coder Hawk 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... –  Coder Hawk May 12 '11 at 11:42

2 Answers 2

up vote 11 down vote accepted

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).

http://www.sqlskills.com/blogs/jonathan/category/Extended-Events.aspx

http://sankarreddy.com/tag/extended-events/

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.

share|improve this answer

SQL Server traces and Profiler can be used for auditing, but as the feature is announced to be deprecated in future versions of SQL Server, it’s not recommended to use this approach moving forward.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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