Perf Tuning in Prod: Plan Forcing, Plan Guides, and Plan Correction

Kendra Little

You need to ensure that queries in SQL Server or Azure SQL run fast, even when cached execution plans are reused. Could it help to use plan forcing or hints in production? What about newer Intelligent Query Processing (IQP) features? You’ve got so many options that it’s hard to know what to test first, much less how these features interact with one another.

Join Kendra Little for an overview and critique of Plan Forcing and Plan Hints in Query Store, Parameter Sensitive Plan Optimization, Automatic Plan Correction, and good old fashioned Plan Guides. You’ll learn where each of these features is strong, what isn’t as easy as it looks, and how to avoid pitfalls that can cause these features to tank your performance.