open object spinlock ratio

(Multiprocessing systems only) open object spinlock ratio specifies the number of object descriptors that are protected by one spinlock.

Summary Information

Default value

100

Range of values

1–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration group

Meta-Data Cache

SAP ASE uses a spinlock to protect an object descriptor, since more than one process can access the contents of the object descriptor.

The default value for this parameter is 100; 1 spinlock for each 100 object descriptors configured for your server. If your server is configured with only one engine, SAP ASE sets only 1 object descriptor spinlock, regardless of the number of object descriptors.

If one spinlock is shared by too many object descriptors, it causes spinlock contention. Use sp_sysmon to get a report on spinlock contention. See the Performance and Tuning Series: Monitoring SAP Adaptive Server with sp_sysmon.

If sp_sysmon output indicates an object descriptor spinlock contention of more than 3 percent, try decreasing the value of the open object spinlock ratio parameter.

See System Administration Guide: Volume 2 > Managing Mulitprocessor Servers.