Webcast : To Force Plans, Or Not to Force Plans, That Is The Question

Presenter: Kendra Little

We have new ways to force execution plans in SQL Server. In SQL Server 2017, you can even let SQL Server temporarily force query plans for you and test if it works well! In this session, you’ll learn how forcing plans with Query Store compares with the older technology of Plan Guides. You’ll learn how to tell when a plan has been forced, what “morally equivalent plans” are (and why they’re a good thing), how to see if a query has a high variation in performance, and how to decide, “Should I force this plan?” and “Should I let SQL Server force plans for me?” About Kendra: Kendra Little teaches database administrators and developers how to speed up their Microsoft SQL Servers consistently. She is a Microsoft Certified Master in SQL Server, a Microsoft Most Valuable Professional (MVP), and one of the few artists in the world to draw both dinosaurs and databases.

Topics : Database Diagnostics,Database Monitoring,Database Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Webcast

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.