By default, the locking system escalates to a table-level lock after locking 50 pages or rows during a query.

By changing the value for MAXLOCKS to a number greater than 50, you can increase the number of locks that are requested before escalation occurs.

Increasing this value requires more locking system resources, so the installation configuration for the maximum number of locks must be raised; but this can provide better concurrency in a table.