Troubleshooting Plan Changes with Query Store in SQL 2016

Abstract:

Have you ever had random performance problems with a particular query? Have you noticed different execution plans for the same query? In this session were going to cover how execution plans get invalidated and why data skew could be the root cause to seeing different execution plans for the same query. We will look at options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using a new feature in SQL Server 2016 called Query Store. Goals: 1. Learn how execution plans are created and removed from plan cache 2. Understand how and why execution plans change 3. Learn how to lock in an execution plan for a given query.

Speakers:

  • John Sterrett

    19 Recordings
    John's experience leading large technical teams in complex environments has made him a global expert in performance and scalability. John speaks at conferences around the world on database strategy and topics related to performance tuning, development, and cloud computing. He is a Microsoft Certified Trainer, is the principal consultant and founder at Procure SQL.

Recorded At:

Recorded on:

Oct 20, 2015

More Info:

http://cactuss.sqlpass.org/Home.aspx?EventID=4049

Tags:

  • SQL 24 Recordings