SQL Server 2022 Performance Enhancements

on YouTube ↗50m

" summary

Covers concrete 2022 changes and outcomes: availability group redo uses a global redo thread pool (observed up to 17 threads on a 144‑core host), tempdb GAM/SGAM concurrency is fixed, buffer‑pool scans become parallel (previous failovers cost ~3 minutes), and Accelerated Database Recovery gives near‑instant rollbacks but PVS cleanup can balloon (one incident grew to ~300 GB when a long transaction blocked cleanup). Stack dumps are compressed in memory (~92% seen), Query Store persists memory‑grant feedback and enables Query Store hints and automatic plan correction.

AI-written summary · about

" chapters (13)

1. 0:00Introduction to SQL 2022
2. 1:41Key performance improvements
3. 3:50Availability groups and redo
4. 8:26Tempdb and system efficiency
5. 10:24Buffer pool scan optimization
6. 12:31Accelerated database recovery
7. 19:41Stack dump improvements
8. 22:43Parameter sensitive optimization
9. 30:45Memory grant feedback
10. 36:51DOP and estimator feedback
11. 40:03Optimizer feedback mechanisms
12. 43:27Automatic plan correction
13. 45:47Query store hints and conclusion

" related talks

• 50mSQL Server 2022 Performance EnhancementsOla Hallengren · SQLBits 2022
• 51mNext Level Scalability on SQL Server 2022Ajay Jagannathan, David Pless · SQLBits 2023
• 49mPerformance Improvements in SQL Server 2019Frank Gill · SQL Server Virtual Conference 2021
• 47mNext Level Availability on SQL Server 2022David Pless · SQLBits 2023
• 48mSQL Server 2022 hidden gemsBob Ward · SQLBits 2023
• 54mSoaring to New Heights with Accelerated Database RecoveryJohn Morehouse · SQLBits 2022
• 49mHidden Gems in SQL Server 2022 Database EngineAjay Jagannathan, Dimitri Furman · SQLBits 2022
• 51mSQL Server 2022 and the Wheel of PowerBob Ward · SQLBits 2023