page lock promotion PCT sets the percentage of page locks (based on the table size) above which SAP ASE attempts to acquire a table lock. 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).
|
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 |
See Performance and Tuning Series: Locking and Concurrency Control > Locking Configuration and Tuning.
The default value for page lock promotion PCT is appropriate for most applications.
You can also configure lock promotion at the object level for page locked objects. See sp_setpglockpromote in the Reference Manual: Procedures.