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