open index hash spinlock ratio

(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.