Microsoft SQL Server 2008: Performance Profiling and Troubleshooting with Extended Events
Imagine tracking and aggregating wait statistics at the session level rather than the server level. Imagine seeing exactly how long each step in your query took and figuring out the real cost of that index scan. Imagine capturing an exception with an associated callstack--no more guessing about exactly what component failed and why. When you're done imagining, open your eyes and attend this session to learn all of these techniques and more, all thanks to Extended Events (XEvents)--the powerful new tracing infrastructure in SQL Server 2008. Designed for DBAs and developers who already understand the basics of XEvents, this session goes from 0 to 60 in the first few minutes. See a number of code examples and gain an understanding of how to maximize XEvents for performance profiling and troubleshooting purposes. If you're serious about making your SQL Servers fly, this is one session not to be missed.