Lock escalation RRS feed

  • Question

  • Lock escalation can only happen when all the locks on the relevant level (page, table) are owned by one and the same connection.

    True or false? 

    As far as I can understand it has to be true, since as far as I understand the point of lock escalation is to get rid of all the underlying locks and replace them with a big one. Hence, if individual rows on a page are locked by different connections, escalation to a page lock cannot happen (at the very least, the row locks can't be forgotten about).

    Monday, November 25, 2013 1:02 PM


  • Correct.

    Tibor Karaszi, SQL Server MVP | web | blog

    • Marked as answer by The Dag Monday, November 25, 2013 2:51 PM
    Monday, November 25, 2013 1:09 PM

All replies