Get Live Help
An area of memory used by SQL Server for managing locks.
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.
An on-disk structure, which contains a record of a database's transactions. A log consists of one or more Files.