what is lock escalation?

Posted by Bkarthik under Sql Server on 8/18/2011 | Points: 10 | Views : 2472 | Status : [Member] | Replies : 4
Hi Friends......

Can any one explain in brief, what is lock escalation and how it is used? Also explain where and why to use it? Hope I get quick response.



Thanks & Regards
Karthik Beeravelli

Karthik Beeravelli


Responses

Posted by: Bkarthik on: 8/18/2011 [Member] Starter | Points: 25

Up
0
Down
Thank You Nithadeepak...



Karthik Beeravelli

Bkarthik, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vforvijay on: 8/18/2011 [Member] Starter | Points: 25
Posted by: perfectchourasia-9163 on: 11/17/2011 [Member] Starter | Points: 25

Up
0
Down
Lock escalation is the process of converting many fine-grain locks, such as a row, into fewer coarse-grain locks, such as a table. Using lock escalation reduces system overhead.

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Bkarthik, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response