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
How can COM Components use in .NET? The .NET components can communicate with COM using RCW (Runtime Callable Wrapper). The ways with which you can generate RCW are as shown bel

What is Dispose method in .NET? The .NET provides "Finalize" method in which we can clean up our resources. But relying on this is not always better so the best is to implement

What' is the sequence in which ASP.NET events are processed? The sequence in which the ASP.NET events occur are as folows :- 1.     Page_Init. 2.     Page_Load. 3.

What is shadowing? When 2 elements in a program have similar name, one of them can hide and shadow the one. Therefore in such cases the element which shadowed the main element

What is the difference between Shadowing and Overriding? The main basic difference between shadowing and overriding are as follows:- 1) The Overriding redefines only the imp

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 DBMS? It is a collection of programs that enables user to make and maintain a database. In other words it is general-purpose software that gives the users with the proc

Mention the name of the directory where it is essential to locate the proxy file to use a Web service. The proxy file must be kept in the /bin directory. This directory is situ

I need Isometric Exploration Tablet Game I am endeavoring to build an 2D tile-based isometric game, primarily for Android and iOS tablet devices. It will be built in Unity 3d v4

I want a C# Windows App Project Description: Windows App written in C# that can: Check for Internet connection Load dynamic web site If Internet connection drops rec