Wednesday 1:45 PM - 2:45 PM · C202-C204

Exploring Optimized Locking in SQL Server 2025

Updating data in SQL Server can lead to lock escalation, blocking, deadlocks, or slow performance if it isn't done correctly. The newly released optimized locking helps reduce these issues while improving concurrency. This session explores how it works—covering its architecture, implementation, and best practices to maximize performance to help reduce those dreaded locking issues!