What is Lock escalation ?

 Posted by Pandians on 7/23/2009 | Category: Sql Server Interview questions | Views: 3470
Answer:

The process of converting many fine-grain locks into fewer coarse-grain locks.
ie:
fine-grain = ROW
coarse-grain = TABLE


Asked In: In General | Alert Moderator 

Comments or Responses

Login to post response