22-25 April 2026
Book Now
SQLBits 2024

SQL Server 2022 Performance Enhancements

In this session we are going to look at the performance enhancements in SQL Server 2022. We will cover the most important enhancements in the optimizer (intelligent query processing), storage engine, Accelerated Database Recovery, availability groups, Query Store, stack dumps and some more. Which problems are the features solving? How are they doing it? I will share some real-world experiences of the features, from running SQL Server 2022 on mission-critical databases.
In this session we are going to look at the performance enhancements in SQL Server 2022. We will cover the most important enhancements in the optimizer (intelligent query processing), storage engine, Accelerated Database Recovery, availability groups, Query Store, stack dumps and some more.

Which problems are the features solving? How are they doing it?

I will share some real-world experiences of the features, from running SQL Server 2022 on mission-critical databases.

Speakers

Ola Hallengren

Ola Hallengren's other proposed sessions for 2026

The Latest Performance Improvements in Azure SQL Database, Managed Instance, and SQL Server 2025 - 2026

Ola Hallengren's previous sessions

SQL Server 2022 Performance Enhancements
In this session we are going to look at the performance enhancements in SQL Server 2022. We will cover the most important enhancements in the optimizer (intelligent query processing), storage engine, Accelerated Database Recovery, availability groups, Query Store, stack dumps and some more. Which problems are the features solving? How are they doing it? I will share some real-world experiences of the features, from running SQL Server 2022 on mission-critical databases.