SQL Server Versioning Explained
Proposed session for SQLBits 2026TL; DR
Version store, Accelerated Database Recovery, Optimized Locking, and RSCI. What do these all have in common? Versioning. In this session the mysteries of SQL Server versioning will be unlocked.
Session Details
Version store, Accelerated Database Recovery (ADR), Optimized Locking (OL), and RSCI. What do these all have in common? Versioning. In this session the mysteries of SQL Server versioning will be unlocked. You will learn the internals of how it all works, what to use and when, and examples including how to debug it. And we will bring the numbers so you will see exactly how your SQL workload will be affected by using versioning. You will walk aways not just learning how things work but details to help you decide whether you should use options like ADR or OL.
3 things you'll get out of this session
1. Understand how versioning works with all the different options
2. Learn the value and impact to using versioning
3. Experience a "Data Internals - Blow your mind" session