Post reply

Lock escalation

  • July 21, 2009 at 6:34 pm

    #202705

    How can I detect lock escalation on a table in SQL Server 2005? We have a stored procedure processing 2000 records at a time using with (RowLock). We want to increase the number to whatever number that SQL Server won't escalate to a page or table lock, but I don't know how to check the lock status of table.

    Thank you in advance for any helps.

  • July 27, 2009 at 12:34 pm

    #1030689

    hmmmmmm......experts must be on vacation or sick of my questions.

    Anyway I don't need answers for this now. ^_^

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

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