page lock promotion PCT

Summary information

Default value

100

Range of values

1–100

Status

Dynamic

Display level

Intermediate

Required role

System Administrator

If the number of locks held on an object is between page lock promotion LWM (low-water mark) and page lock promotion HWM (high-water mark). page lock promotion PCT sets the percentage of page locks (based on the table size) above which Adaptive Server attempts to acquire a table lock.

For more detailed information on setting up page lock promotion limits, see “Configuring locks and lock promotion thresholds” in Performance and Tuning: Locking.

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

You can also configure lock promotion at the per-object level for page locked objects. See sp_setpglockpromote in the Reference Manual.