Summary information |
|
|---|---|
Default value |
100 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System Administrator |
open index hash spinlock ratio sets the number of index metadata descriptor hash tables that are protected by one spinlock. This parameter is used for multiprocessing systems only.
All the index descriptors belonging to the table are accessible through a hash table. When a query is run 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. You can get information about spinlock contention by using sp_sysmon. For more about sp_sysmon, see the Performance and Tuning Guide.
For more information about configuring spinlock ratios, see “Configuring spinlock ratio parameters”.
