Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Lock Escalation RE: Lock Escalation

  • May 25, 2011 at 3:04 am

    #1329542

    mohammed moinudheen (5/25/2011)

    I thought row level locks would be escalated to table locks only.

    I referred the link provided in the answer, but couldn't find any information regarding escalation to partition.

    The Database Engine does not escalate row or key-range locks to page locks, but escalates them directly to table locks. Similarly, page locks are always escalated to table locks. In SQL Server 2008, locking of partitioned tables can escalate to the HoBT level for the associated partition instead of to the table lock. A HoBT-level lock does not necessarily lock the aligned HoBTs for the partition.

    Did anyone find more information regarding the escalation of row level locks to partition in the link provided?

    I inferred it from the same paragraph that you quoted. If a row lock can escalate to a table lock, and a table lock can escalate to a partition lock then a row lock can cause a partition lock.