Troubleshooting Plan Changes with Query Store in SQL 2016




  • Start Date:
    Nov 12 2015 at 10:00
  • End Date:
    Nov 12 2015 at 11:00
  • Timezone:
    (GMT-08:00) Pacific Time (US & Canada)
  • Location:
    Online Event
  • Event Name:
    Troubleshooting Plan Changes with Query Store in SQL 2016
  • Description:

    Troubleshooting Plan Changes with Query Store in SQL 2016 

    Wednesday, November 12, 2015
    10:00am Pacific / 12:00pm Central / 1:00pm Eastern

    Have you ever had random performance problems with a particular query? Have you noticed different execution plans for the same query? 

    Join John Sterrett, Senior Advisor at Linchpin People and Scott Walz, Director of Software Consultants, to learn 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.
  • Categories:
    Web Seminars
  • Seats available:
    Unlimited Seats
  • Tags:
    SQL Server Webinar