SQL Server Society of Las Vegas Monthly Meeting

Troubleshooting Execution Plan Changes with Query Store in SQL 2016

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

Join John Sterrett, Group Principal at Linchpin People 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:

• Learn how execution plans are created and removed from plan cache.

• Understand how and why execution plans change.

• Learn how to lock in an execution plan for a given query.

Speaker Bio: John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a PASS Regional Mentor, leader of the Austin SQL Server User Group and founder of the HADR Virtual Chapter.

Join us virtually at https://global.gotomeeting.com/join/807251549

You can also dial in using your phone.United States +1 (408) 650-3123
Access Code: 807-251-549