Reading Execution Plans: The Deep Dive
A talk by
About the Talk
June 9, 2011 2:30 PM
Richmond SQL Server Users GroupRichmond 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.