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 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.
The default value for row lock promotion PCT is appropriate for most applications.
For more information on setting up lock promotion limits, see Chapter 2, “Locking Configuration and Tuning,” in Performance and Tuning Series: Locking and Concurrency Control.
You can also configure row lock promotion at the per-object level. See sp_sterowlockpromote in the Reference Manual: Procedures.
