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 |
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.
See Chapter 2, “Locking Configuration and Tuning,” in the Performance and Tuning Series: Locking and Concurrency Control.
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.
