Summary information |
|
|---|---|
Default value |
100 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System administrator |
Configuration group |
Meta-Data Cache |
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. open object spinlock ratio is used only in multiprocessing systems..
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 Series: Monitoring Adaptive Server with sp_sysmon.
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.
See Chapter 5, Managing Mulitprocessor Servers,” in System Administration Guide: Volume 2.
