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” on page 286 in the Performance and Tuning Guide.
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.
