LockThreshold
Set the SQL table-level lock threshold.
Synopsis
n is any nonnegative integer. The default value is 1000.
Description
The LockThreshold parameter is the automatic lock escalation threshold. This is the number of inserts, updates, or deletes for a single table within a single transaction that will trigger a table-level lock when reached.
Consider this example: a process starts a transaction that inserts 2000 rows, where LockThreshold is set to 1000. After the 1001st row is inserted, the process attempts to acquire a table-level lock rather than continue to lock individual rows. This reduces the total number of locks to prevent the lock table from becoming too full.
Automatic lock escalation is intended to prevent overflow of the lock table. For further details, see Modify Transaction Lock Threshold.
See Also