Post reply

Lock escalation

  • July 7, 2011 at 1:02 am

    #239202

    [font="Times New Roman"]

    Hello Everyone,

    If lock escalation has happened from row locks to table lock. Now is it possible that table lock is converted to row locks or table lock would be table lock until released.

    Regards,

    Anil

    [/font]

  • July 7, 2011 at 2:57 am

    #1349488

    It will stay a table lock. SQL escalates to reduce the resources required. It's not going to go and undo that and go back to the high resources used that caused the escalation in the first place.

    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

  • July 7, 2011 at 3:07 am

    #1349498

    [font="Tahoma"]

    Thanx a lot Gail.

    [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply