An object used by a software, such as SQL Server, to indicate that a user has an interest in a resource, and to prevent multiple users accessing the same resource in conflicting ways simultaneously. The simplest example is to prevent two people from updating the same information at the same time.
The process of converting many lower level locks into fewer higher level locks, and reducing system overhead. For example, if a user has many row-level locks on a table, SQL Server may escalate these into a single table-level lock.
A lock mode (for example: Shared, Exclusive, Intent Exclusive) indicates the level of dependency a user has on a lock, and is used for determining which locks can be granted simultaneously on a resource.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center