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 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 Adaptive Server attempts to acquire a table lock.
For more information on setting up lock promotion limits, see “Configuring locks and lock promotion thresholds” in Performance and Tuning: Locking.
The default value for row lock promotion PCT is appropriate for most applications.
You can also configure row lock promotion at the per-object level. See sp_sterowlockpromote in the Reference Manual.
