Results 1 to 2 of 2

Thread: lock escalation

  1. #1
    Join Date
    Jun 2012

    Unanswered: lock escalation

    can any one help on this to explain what is lock escalation?

  2. #2
    Join Date
    Jan 2012
    Provided Answers: 1
    Hello Kumz,

    Lock escalation is the process of converting a lot of low
    level locks (like row locks, page locks) into higher level
    locks (like table locks).

    A table lock is more efficient than multiple page or row locks when an entire table might eventually be needed. At first, a task acquires page or row locks, then attempts to escalate to a table lock when a scan session acquires more page or row locks than the value set by the lock promotion threshold.
    From sybase manual.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts