Tomaz Kastrun continues an advent of SQL Server 2025:
Optimized locking is a new feature in SQL Server 2025. It helps to reduce lock memory as very few locks are held even for large transactions. In addition, optimized locking avoids lock escalations and can avoid certain types of deadlocks. This allows more concurrent access to the table.
Read on to understand what its purpose is and see a demo of it in action.