With the release of the PASS Summit 2012 schedule, I’m pleased to announce that I have been selected to present two Spotlight session at this years summit. It’s cool to be selected to be a part of the spotlight speakers, not sure who I fooled to get into this group.
The sessions I am doing this year are the same topics as last year, with the exception that I get 15 more minutes; which will likely mean a good reason to revamp the sessions. So, even if you attended either of them last year, they will be different enough that the session will be worthwhile to attend again this year. Though the comparison between XML and gothic teens may need to stay in the session.
Of the many ways to monitor your SQL Server environment, Extended Events is one of the newer platforms that can help you investigate and resolve performance problems. In this special 90-minute session, we’ll review Extended Events and learn the ins and outs of how to get and analyze detailed information on the errors and events that occur within SQL Server. With a few T-SQL statements, you can research in minutes issues that used to take weeks to investigate.
After execution, execution plans are stored in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. By using XQuery to browse and search the plan cache, you can find potential performance issues and opportunities to tune your queries. You can use this information to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or discover exactly which queries are using what indexes. All of this and more is readily available through the plan cache. In this session, we will explore the plan cache and start you on the road to discovery.
If you are interested in attending either, make sure you are coming to the PASS Summit this year. Also, let me know what you want me to be sure that I cover in the session in the comments for this post.