Coming right off a excellent weekend in Central Florida with SQL Saturday, PASS Summit is now less than two weeks away. Hopefully by now you have already registered since there was a lower price for early registration, but in the event that you haven't there is still time to register. This will be the first major conference that I will be attending where I will also be speaking. I'll be presenting Opening the SQL Server 2008 Troubleshooting Toolbox: An Introduction to Extended Events which should be a good introduction, leading into Adam Machanic's Spotlight session Advanced SQL Server 2008 Extended Events: Performance Profiling and Troubleshooting Techniques.
Opening the SQL Server 2008 Troubleshooting Toolbox: An Introduction to Extended Events
Presenter: Jonathan Kehayias (OSI Restaurant Partners)
New in SQL Server 2008, Extended Events bring a refreshing new deep look at what actually happens inside the Database Engine. This session will focus on how to use the default system_health session to perform initial troubleshooting, and how to create custom sessions using the available events, targets and actions available in the Extended Events metadata. The session will wrap up with how to use the information stored in the targets to solve specific problems.
Advanced SQL Server 2008 Extended Events: Performance Profiling and Troubleshooting Techniques
Presenter: Adam Machanic (SQLblog.com)
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 which component failed and why. When you're done imagining, open your eyes and attend this session, where you will learn all of these techniques and more, all thanks to Extended Events (XEvents)--SQL Server 2008's powerful new tracing infrastructure. Designed for DBAs and developers who already understand the basics of XEvents, this session will go from 0 to 60 in the first few minutes. You will see a number of code examples and gain an understanding of how to maximize XEvents for performance profiling and troubleshooting purposes. If you are serious about making your SQL Servers fly, this is one session not to be missed.
If you are interested in Extended Events in SQL Server 2008, these are two can't be missed sessions for PASS. Hope to see you there.