SQL Server Performance Tuning and Optimization

SQT11 Exploring Execution Plans


4:15pm - 5:30pm

Level: Intermediate

Grant Fritchey

Product Evangelist

Redgate Software

Getting started reading execution plans is very straightforward. The real issue is understanding the plans as they grow in size and complexity. This session will show you how to explore the nooks and crannies of an execution plan in order to more easily find the necessary information needed to make what the plan is telling you crystal clear. The information presented here will better empower you to traverse the execution plans you'll see on your own servers. That knowledge will make it possible to more efficiently and accurately tune and troubleshoot your queries.

You will learn:

  • Where the behavioral details are found within execution plans
  • The types of information found within execution plans
  • About new methods of exploring execution plans