user log cache spinlock ratio

For SAP ASEs running with multiple engines, user log cache spinlock ratio specifies the ratio of user log caches per user log cache spinlock. There is one user log cache for each configured user connection.

Summary Information

Default value

20

Range of values

1–2147483647

Status

Dynamic

Display level

Intermediate

Required role

System administrator

Configuration groups

Memory Use, User Environment

The default specifies 1 spinlock for each 20 user connections configured for your server.

Use sp_sysmon to understand how this parameter affects cache behavior. See the Performance and Tuning Series: Monitoring SAP Adaptive Server with sp_sysmon.