SQL Server Administration and Maintenance

SQW12 Exploring Execution Plans


4:00pm - 5:15pm

Level: Introductory to Intermediate

Grant Fritchey

Product Evangelist

Red Gate Software

Getting started reading execution plans is very straight forward. 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:

  • How to read execution plan properties to identify the most useful data in various situations
  • How to use the new tools available in SQL Server 2016 that show how execution plans and queries behave
  • How to apply the tools and techniques from this session in order to better and more efficiently tune a query