Summary information |
|
|---|---|
Default value |
100 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
open object spinlock ratio specifies the number of object descriptors that are protected by one spinlock. Adaptive Server uses a spinlock to protect an object descriptor, since more than one process can access the contents of the object descriptor. This configuration parameter is used for multiprocessing systems only.
The default value for this parameter is 100; 1 spinlock for each 100 object descriptors configured for your server. If your server is configured with only one engine, Adaptive Server sets only 1 object descriptor spinlock, regardless of the number of object descriptors.
If one spinlock is shared by too many object descriptors, it causes spinlock contention. Use sp_sysmon to get a report on spinlock contention. See the Performance and Tuning Guide for more information on spinlock contention. If sp_sysmon output indicates an object descriptor spinlock contention of more than 3 percent, try decreasing the value of the open object spinlock ratio parameter.
For more information about configuring spinlock ratios, see “Configuring spinlock ratio parameters”.
