What is lock escalation?

What is lock escalation?

- Lock escalation is the process of converting low level locks (row locks, page locks) into higher level locks (table locks).

- Each lock is a memory structure. Too many locks mean more memory being occupied by locks.

- SQL Server escalates the many fine-grain locks to fewer coarse-grain locks.

- Lock escalation means the conversion of a lock to a more restrictive mode.

- When lock escalation occurs, the lock is selected for the heap or index is strong enough to meet the requirements of the most restrictive lower level lock.
Define SQL Profiler
SQL Profiler is used to diagnose a problem by capturing events in a trace file......
Explain SQL Server Service Manager
SQL Server Service Manager is used to start, stop, and pause SQL Server services that exist as the separate components on the server......
What is SQL Query Analyzer?
SQL Query Analyzer is a tool that are used for various purposes such as creating and executing queries.........
Post your comment