row lock promotion PCT

If the number of locks held on an object is between row lock promotion LWM (low-water mark) and row lock promotion HWM (high-water mark), row lock promotion PCT sets the percentage of row locks (based on the number of rows in the table) above which SAP ASE attempts to acquire a table lock.

Summary Information

Default value

100

Range of values

1–100

Status

Dynamic

Display level

Intermediate

Required role

System administrator

Configuration groups

Lock Manager, SQL Server Administration

The default value for row lock promotion PCT is appropriate for most applications.

For more information on setting up lock promotion limits, see Performance and Tuning Series: Locking and Concurrency Control > Locking Configuration and Tuning.

You can also configure row lock promotion at the per-object level. See sp_sterowlockpromote in the Reference Manual: Procedures.