Summary information |
|
|---|---|
Default value |
85 |
Range of values |
1–2147483647 |
Status |
Static |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration groups |
Lock Manager, Memory Use |
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 lock hashtable size.
For Adaptive Servers running with multiple engines, 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.
The Adaptive Server 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. See Chapter 5, Managing Mulitprocessor Servers,” in System Administration Guide: Volume 2.
sp_sysmon reports on the average length of the hash chains in the lock hash table. See the Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.
