The Lock Escalation Threshold – Part 1
SQL Performance
SEPTEMBER 6, 2022
This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Testing environment. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists. . -- Not required, but it makes the later tests more precise. USE Escalation ; GO.
Let's personalize your content