If you are interested in listening to my sultry Minnesota voice this Thursday, you have the opportunity to do it… and twice! Think of it as a late Valentine’s present.
Over the course of the day, I’ll be doing two webcast. The first presentation will be through Digineer, the consulting firm I work for, to talk about querying the plan cache. Later later in the day, I’ll be online with the Edmonton SQL Server user group for a session on extended events.
Below are the details for both sessions…
Discovering the Plan Cache
Date: Thursday, February 16, 2012
Time: 1:00 PM – 2:00 PM CT
Execution plans are stored (after execution) in the plan cache. This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning. Using XQuery to browse and search the plan cache can help you find potential performance issues and opportunities to tune your queries. Additionally, this information can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or simply just discovering exactly which queries are using what indexes. All of this and more is readily available through the plan cache.
Extended Events, Work Smarter Not Harder
Date: Thursday, February 16, 2012
Time: 6:30 PM – 8:00 PM CT
There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
Related posts:
- PASS Summit 2011 Session Materials
- TechFuse 2011 – This Month
- PASS Summit Evals – Plan Cache Querying
