Home > DeveloperSection > Interviews > What is lock escalation?

Posted on    January-14-2011 12:00 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1258  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

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