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
Explain all parts of a deployment diagram. Package: - The package logically groups element of a UML model. Node: - The Node is as physical system which represents a

What is project management? Applying the knowledge, skills, techniques, tools in project and deliver project deliverable is a short definition of the project management. It's b

upload files using file upload control to google drive

Slide Bettween Window Application 1 Project Description: Like Mouse Gesture. Keep Right Mouse, Slide Left and drop right mouse. Move to earlier app on taskbar. Keep Lef

Can a .NET web application consume Java web service? Yes Offcourse.Actually Webservices are independent  to language. It depends on WSDL and SOAP. so any one can develope the W

What is a Cloud Service? A cloud service is used to build cloud applications. This service gives the facility of using the cloud application without installing it on the comput

How can we create custom controls in ASP.NET? The User controls are created using .ASCX in ASP.NET. After that .ASCX file is created you need two things in order to that the AS

What's the use of resource manager class? The ResourceManager class helps us to read the resource files and get the values by using key. At First you require to create the obje

Our company is seeking a talented PHP Developer to join our young and dynamic online media agency. Must have: - Knowledge in SQL and Databases, proven indexing and coding exp

Introduction This assignment aims to give you a "real world experience" that occurs far too often in the workplace. You have been hired to complete as much as possible a project