Do you struggle to understand why a query is running slowly? Or why it runs in less than a second most of the time, and takes 10 minutes other times? Being able to review and understand query execution plans is essential to understand bottlenecks in database performance. While DBAs need to be able to understand execution plans, but for proactive performance management developers need to be able to review plans as queries and procedures get developed. In this session you will learn you how to gather and read execution plans, understand what query operators are and what actions they perform, understand the differences in plan types. Finally, you will learn how to improve your code and it’s performance by using the data revealed in these plans.

We have identified queries that are slow. We got the execution plans for these queries but don't know how to read them. We are unsure what operators in the execution plan led to slow query performance.