Summary information |
|
|---|---|
Default value |
85 |
Range of values |
1–2147483647 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System Administrator |
Adaptive Server manages the acquiring and releasing of locks using an internal hash table with a configurable number of hash buckets. On SMP systems, this hash table can use one or more spinlocks to serialize access between processes running on different engines. To set the number of hash buckets, use the lock hashtable size.
For Adaptive Servers running with multiple engines, the lock spinlock ratio sets a ratio that determines the number of lock hash buckets that are protected by one spinlock. If you increase lock hashtable size, the number of spinlocks increases, so the number of hash buckets protected by one spinlock remains the same.
Adaptive Server’s default value for lock spinlock ratio is 85. With lock hashtable size set to the default value of 2048, the default spinlock ratio defines 26 spinlocks for the lock hash table. For more information about configuring spinlock ratios, see “Configuring spinlock ratio parameters” of the System Administration Guide.
sp_sysmon reports on the average length of the hash chains in the lock hash table. See the Performance and Tuning Guide for more information.
