Interested to Buy Any Domain ? << Click Here >> for more details...
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 stretch database in sql server?
Which sql server table is used to hold the stored procedure scripts?
What is the standby server?
How can you control the amount of free space in your index pages?
What is equi join with example?
How to modify existing triggers using "alter trigger"?
Can foreign key be duplicate?
How to connect of datebase with sql express.?
What does it mean to normalize a database and why would you do it?
Explain database normalization?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Explain nested join?
How many database files are there in sql server 2000?what are they?
How to get the definition of a view out of the sql server?
Explain the commands in sql server?
