Main Content

Using XML to Query Execution Plans

About the Talk

July 28, 2010 8:00 AM

Live Meeting

Live Meeting

SQL Server stores its execution plans as XML in dynamic management views. The execution plans are a gold mine of information. From the whether or not the execution plan will rely on parallelism to what columns are requiring a key lookup after a non-clustered index seek. Through a the use of XML this information can be available at your fingertips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases. In this session we'll look at how you can begin to understand and query the structure of the execution plans in the procedure cache. Also, we'll review how to uncover some potential performance issues that may be lurking in your SQL Server.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus