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
Small website using ASP.NET MVC 4 EntityFramework 5 Project Description: We are seeking a developer to a ASP.NET MVC4 EntityFramework website using the subsequent tools: Visu

What's difference between Datagrid, Datalist and repeater? The Datalist ,Datagrid, and Repeater are all ASP.NET data Web controls. They have many things in common such as Da

Project Description: I have a basic C# control interface that I want to be accessed remotely. Possible implementation using wrappers. Skills required are C# Programming, Webs

Write the basic syntax of a LINQ query in Visual Basic as well as in C#. In Visual Basic, the basic syntax of a LINQ query begins with the from clause and ends with the Select

If one of your validations is complicated and does not fit in any validators, what you do? The best way is to go for CustomValidators. The sample code for a custom validator

The Events are always public as they are meant to serve each one registering to it. But you can access modifiers in the events.You may have events with protected keyword which will

What is difference between abstract classes and interfaces? The difference b/w abstract and interfaces are s follows:- 1.     The Abstract classes can have concrete methods

They are triggered in the following order as shown below: Application_BeginRequest Application_AuthenticateRequest Application_AuthorizeRequest Application_ResolveReque

What is fundamental of published or precreated objects in Remoting? In the scenarios of the singleton or single call the objects are created dynamically. But in some situations

What does a break statement do in the switch statement? The switch statement is a selection control statement that is used to handle many choices and transfer control to the ca