SQLBits 2014

Getting Started Reading Execution Plans

Learn where to start reading execution plans and how to interpret them in order to understand how to tune poorly performing queries.
The best way to understand why your query is running slow is to look at the execution plan. But, knowing how to get started in execution plans, what to look for, what's important, can all be terribly confusing. This session will provide you with a simple set of tasks to get you started reading execution plans. You'll learn where to start, what to look for first, and you'll be better prepared to tune your queries. We'll also look at some methods you can use to write queries against the plans themselves in order to more easily and quickly identify potential issues within your plans. The information presented will be immediately applicable on the queries you have running back in the office.