The Lock Escalation Threshold – Part 3
SQL Performance
OCTOBER 20, 2022
Lock Lifetimes. The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use. Locking optimizations. When SQL Server reads data under locking read committed isolation (the default for non-cloud offerings) and chooses row-level locking granularity, it normally only locks one row at a time.
Let's personalize your content