Answer Posted / swapna
Lock escalation is the process of converting a lot of low
level locks (like row locks, page locks) into higher level
locks (like table locks). Every lock is a memory structure
too many locks would mean, more memory being occupied by
locks.
To prevent this from happening, SQL Server escalates the
many fine-grain locks to fewer coarse-grain locks. Lock
escalation threshold was definable in SQL Server 6.5, but
from SQL Server 7.0 onwards it's dynamically managed by SQL
Server.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is raid, and how it can influence database performance?
What is the contrast between sql and pl/sql?
How ssrs maintain security?
Which tcl commands are available on the sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
Mention the differences between having and where clause.
What happens if the update subquery returns no rows in ms sql server?
What is pessimistic concurrency?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Explain the disadvantages/limitation of the cursor?
What is side by side migration in sql server?
what purpose does the model database serve? : Sql server database administration
what is the information that can be stored inside a bit column? : Sql server database administration
Why do we partition data?
What is compression - row-level and page-level compression?
