One of the newer features introduced in Azure SQL Database is “Optimized Locking”. But what does that mean, and how does it compare to the apparently “un-optimized” locking the SQL relational engine has been using up to this point? Let’s dive in and take a look.
Read on to learn more about optimized locking and how it compares to the traditional form of locking available in SQL Server today.