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
Explain the advantages of merge replication?
How extra digits are handled with numeric data type literals?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What do you mean by an execution plan? Why is it used? How would you view it?
How do I create an extended event in sql server?
on line cluster can we make if yes tell me the procedure
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What are constraints in microsoft sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How does recursive cte works in sql server?
How to end a stored procedure properly in ms sql server?
What is stored in the mssqlsystemresource database? : sql server database administration
How to create function without parameter in sql server?
What are the differences between web role and worker role?
What is clr ddl trigger?
