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.
