Summary information |
|
|---|---|
Default value |
100 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System administrator |
Configuration groups |
Memory Use, Meta-Data Cache |
open index hash spinlock ratio sets the number of index metadata descriptor hash tables that are protected by one spinlock. This parameter is used only in multiprocessing systems only.
All the index descriptors belonging to a table are accessible through a hash table. When you run a query on the table, Adaptive Server uses hash tables to look up the necessary index information in its sysindexes rows. A hash table is an internal mechanism used by Adaptive Server to retrieve information quickly.
Usually, you do not need to change this parameter. In rare instances, however, you may need to reset it if Adaptive Server demonstrates contention from hash spinlocks. See the Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.
For more information about configuring spinlock ratios, see Chapter 5, “Managing Multiprocessor Servers,” in the System Administration Guide: Volume 2.
