page lock promotion LWM (low-water mark), with page lock promotion HWM (high-water mark) and the page lock promotion PCT, specify the number of page locks permitted during a single scan session of a page locked table or an index before SAP ASE attempts to promote from page locks to a table lock.
|
Summary Information |
|
|---|---|
|
Default value |
200 |
|
Range of values |
2–value of page lock promotion HWM |
|
Status |
Dynamic |
|
Display level |
Intermediate |
|
Required role |
System administrator |
|
Configuration groups |
Lock Manager, SQL Server Administration |
The page lock promotion LWM sets the number of page locks below which SAP ASE does not attempt to issue a table lock on an object. page lock promotion LWM must be less than or equal to page lock promotion HWM.
The default value for page lock promotion LWM is sufficient for most applications. If SAP ASE runs out of locks (except for an isolated incident), increase number of locks.
See the Performance and Tuning Series: Locking and Concurrency Control.
You can also configure page lock promotion at the object level. See sp_setpglockpromote in the Reference Manual: Procedures.