Home > DeveloperSection > Interviews > What is lock escalation?

Posted on    January-14-2011 12:00 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1113  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Points:690
Posted on    January-14-2011 1:00 AM

When the number of row, page locks held per tablespace 
exceeds the LOCKMAX value or NUMLKUS or NUMLKTS, the lock
is escalated to a tablespace lock.

Don't want to miss updates? Please click the below button!

Follow MindStick