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
If no size is defined while creating the database, what size will the database have?
What is ems sql management studio? : sql server management studio
What are the differences between union, intersect, and minus operators?
What is the difference between value type and reference type?
What are the different types of data sources in ssrs?
What are four major operators that can be used to combine conditions on a where clause?
Explain timestamp datatype?
Do you know the policy based administration feature of sql server 2008?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
what is nonclustered index
Explain how to use linked server?
What are the kinds of subquery?
How to receive output values from stored procedures?
What is difference between createstatement and preparedstatement?
What is rank function?
