Exploring SQL Server 2022’s Performance Enhancements

Ola Hallengren

Join me for an insightful session diving into the world of performance enhancements in SQL Server 2022. We’ll embark on a journey through the latest advancements of Intelligent Query Processing, including Parameter Sensitive Plan optimization, memory grant feedback, cardinality estimation feedback, and degree of parallelism feedback. Additionally, we’ll navigate through enhancements to Accelerated Database Recovery, availability group redo, buffer pool scans, and page latch concurrency.

But that’s not all – we’ll also uncover the advancements made to Query Store and Automatic Plan Correction, along with improvements to SQL Server stack dumps and more.

For each feature, we’ll examine the specific problems it addresses, explore how it resolves them, and share real-world experiences gained from running SQL Server 2022 on mission-critical databases. Don’t miss this opportunity to gain practical insights and unlock the full potential of SQL Server 2022.