John & Monica Morehouse - Exploring Optimized Locking in SQL Server 2025

When updating data in SQL Server, operators run the gambit of incurring issues if not done correctly. Sometimes, they manifested as lock escalation, the dreaded blocking, disastrous deadlocks, or poor performance. With the release of Optimized Locking, first seen in Azure SQL Database and now in SQL Server 2025, issues are mitigated while helping to enhance performance and transactional concurrency. In this session, we'll embark on a journey into this new capability, designed to revolutionize concurrency control and improve transaction throughput. We'll examine the underlying mechanism while providing insights into its architecture, implementation, and best practices for maximizing performance. You will - • Learn how optimized locking works • Discover what it requires to function • Some Gotchas to be aware of Whether you're a seasoned database professional or a curious developer, this session offers a more profound understanding of SQL Servers's optimized locking feature.