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 filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.