Lock escalation, DOT NET Programming

What is LOCK escalation?

The Lock escalation is the process of converting of the low level locks (such as row locks, page locks) into the higher level locks (such as table locks). Each lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, the SQL Server escalates the many fine-grain locks to the fewer coarse-grain locks. The Lock escalation threshold was definable in the SQL Server 6.5, but from the SQL Server 7.0 onwards it is dynamically managed by the SQL Server.

Posted Date: 9/24/2012 4:14:33 AM | Location : United States







Related Discussions:- Lock escalation, Assignment Help, Ask Question on Lock escalation, Get Answer, Expert's Help, Lock escalation Discussions

Write discussion on Lock escalation
Your posts are moderated
Related Questions
Converting temperature from Fahrenheit to Celsius - Program C# I am facing some problems in the code for Converting temperature from Fahrenheit to Celsius. Can anybody suggest

Project Description: Someone to review all our IT systems / dfs replication / set up/ backups etc and give a report. Skills required: SQL, Microsoft Exchange, Windows Serv

What is UML? The Unified Modeling Language (UML) is a graphical language for documenting, specifying, visualizing,  constructing, and  the artifacts of a software-intensive sys

What is boxing in .net

What are the problems that can occur if you do not implement locking properly in SQL SERVER? The problems that occur if you do not implement locking properly in SQL SERVER is a

Develop a windows desktop application Project Description: I am looking to get a desktop application developed. The desktop application will have the subsequent few features:

ASP.NET/MSSQL/ MVC completing backend solution + integrating with frontend. Project Description: System is used for tracking company's activities through several projects by

Explain Interface? An interface is not a class. It is an entity that is explained by the word Interface. An interface has no implementation; it only has the signature or in oth

Find out circumference and area of a circle - C# Program Need Help in Assignment.

What are runtime services? Runtime services having of predefined and user-defined classes that are available to the workflow runtime engine during implementation to customize t