Exploring optimized locking

Kendra Little | December 17, 2023

SQL Server has a new feature that’s currently only available in Azure SQL Database: Optimized Locking.

This is a very interesting capability that looks like it could potentially be a great fit for all sorts of SQL Server implementations in the future. (No insider knowledge here, I just haven’t read about any constraints that mean this couldn’t work well on-prem or in a managed instance if/when Microsoft wants to make it more widely available.)

Here’s a visualization of the concepts involved in Optimized Locking:

Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.