If the number of locks held on an object is between row lock promotion LWM (low-water mark) and row lock promotion HWM (high-water mark), row lock promotion PCT sets the percentage of row locks (based on the number of rows in the table) above which SAP ASE attempts to acquire a table lock.
|
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 |
The default value for row lock promotion PCT is appropriate for most applications.
For more information on setting up lock promotion limits, see Performance and Tuning Series: Locking and Concurrency Control > Locking Configuration and Tuning.
You can also configure row lock promotion at the per-object level. See sp_sterowlockpromote in the Reference Manual: Procedures.