(Multiprocessing systems only) open index hash spinlock ratio sets the number of index metadata descriptor hash tables that are protected by one spinlock.
|
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 |
All the index descriptors belonging to a table are accessible through a hash table. When you run a query on the table, SAP ASE uses hash tables to look up the necessary index information in its sysindexes rows. A hash table is an internal mechanism used by SAP ASE to retrieve information quickly.
Usually, you do not need to change this parameter. In rare instances, however, you may need to reset it if SAP ASE demonstrates contention from hash spinlocks. See the Performance and Tuning Series: Monitoring SAP Adaptive Server with sp_sysmon.
For more information about configuring spinlock ratios, see System Administration Guide: Volume 2 > Managing Multiprocessor Servers.