Louis Davidson tries out a new feature:
A feature I have been trying to find time to write about since it arrived is Optimized Locking, which first shipped in SQL Server 2025. This is a feature that changes the way SQL Server locks manages concurrency in a very interesting number of ways. Most of which, as I start writing this blog, I don’t understand. And I probably won’t when I finish.
What I can promise you is an example rich blog where I examine the impact of this feature.
Read on to see what Louis was able to learn.