How It Works: SQL Server Lock Partitioning
SQL Server According to Bob
SEPTEMBER 9, 2019
A handful of lock types (Database, Metadata, LOGIN_STATS, …) are eligible for lock partitioning. For example: When ‘use database’ takes place the session acquires a shared lock on database. Only distinct changes require an exclusive database lock, for example a drop database.
Let's personalize your content