About the Talk
February 16, 2012 8:00 AM
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.
In this session, MVP Jason Strate will explore the plan cache and start you on your road to discovery.