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
mailer - mail sender Project Description: I want a mailer: -run on Windows Server 2008 -use how many theard i need -more details speak on private Skills required

What is the use of a .disco file? A client application uses a .disco file to locate or discover the documents that have the description of a Web service. The .disco file having

Explain Custom Activities. In addition to the standard activities available within the base activity library, you can make new activities to meet exact business needs. Creating

What is the difference between System exceptions and Application exceptions? All exception is derived from Exception Base class. Exceptions are generated programmatically or ca

ILDASM When it comes to the understanding of the internals nothing can beat ILDASM. ILDASM  converts all the exe or dll into IL code. To run ILDASM you have to go to "C:\Progra

how can we use entity framework in ASP.Net MVC

Explain the difference between XML and HTML. XML explains data while HTML describes how the data should be displayed. Thus, HTML is about displaying information while XML is ab

.NET is Compile Time OR RunTime Environment?   .Net's framework has CLS,CTS and CLR.CTS checks declaration of types at the time when u write code and CLS defines some rules and

Project Description: Looking for a developer who will develop a web portal like zulutrade, some features will be taken from signaltrader the changes ould be like: 1) only cer

I need Kinect Developer c++ We are creating a fitting room with Kinnect and I need some questions answered like how to detect if a person turns around, how to make the clothing