Home Forums SQL Server 2008 SQL Server 2008 - General Lock only one row in update (lock a row) RE: Lock only one row in update (lock a row)

  • March 25, 2013 at 6:25 am

    #1600271

    abitguru (3/25/2013)

    GilaMonster, Can I prevent lock escalation with (LOCK_ESCALATION = DISABLE) ?? So sql not escalate (only in this table)

    You can. So you'd prefer SQL to run out of lock memory, fail any pending queries with an error (out of lock memory) or possibly even crash rather than escalating locks?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass