Using XML to Query Execution Plans

Jason Strate
60 minutes
Track 3
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 finger tips to help determine the value and impact of an index and guide you in improving the performance of your SQL Server databases. Goals: 1. Discuss information available in an execution plan 2. Demonstrate use of XQuery to query execution cache 3. Demonstrate methods to performance tune

Accompanying Material

No material found.

Back to Top cage-aids