Main Content

Reading Execution Plans: The Deep Dive

A talk by

About the Talk

June 9, 2011 2:30 PM

Richmond SQL Server Users Group

Richmond SQL Server Users Group

It’s one thing to know to look for scans instead of seeks, but if you really want to know what’s going on in an execution plan, you need to dive deep. This session will cover reading execution plans from the basics, but goes way beyond the basics to cover as much of the information available within an execution plan as you might possibly ever need. We’ll cover the basics, like looking for fat pipes, but we’ll also go into how to understand how to interpret parameter sniffing and spot when a join operation is not performing the way you would want. We’ll use the graphical plan and the XML behind to thoroughly explore execution plans.

Ratings and Recommendations

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

comments powered by Disqus