SQLUserC (10/2/2012)
Thanks for all the great replies. I had heard of this mapping of Profiler events to extended events, Jonathan, so it's nice to have a link to it. 🙂I will read through some of this stuff. I'm on SQL 2012 so I'd like to get familiar with the Extended Events as I'm hoping I can use them to tune the performance of my SQL applications.
I would personally look at what you can do with DMVs and the plan cache for tuning before running an Extended Events session or Trace against a server. You can get A LOT of data by querying the DMVs and the plan cache. I very rarely, almost never, use Trace or Extended Events for performance tuning. If you have an error or suspected bug, or just want to see how something works, that's where I go to Trace or Extended Events for diagnostic data collection.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]