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” on page 286 in the Performance and Tuning Guide.
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.