Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    California
    Posts
    8

    Unanswered: SQL2K sp3 Lock esclation treshhold

    Does anyone know how many records need to be updated or deleted before SQL SERVER esclates a ROWLOCK to a TABLELOCK.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I swear I saw those numbers. I think it's a percentage of rows affected in respect to total rows. Search for SQL Server Internals.

Posting Permissions

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