partition spinlock ratio

For SAP ASEs running with multiple engines, partition spinlock ratio sets the number of rows in the partition descriptors that are protected by one spinlock.

Summary Information

Default value

10

Range of values

1–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System administrator

Configuration groups

Memory Use, Meta-Data Cache

SAP ASE manages access to table partitions using partition descriptors. Each partition descriptor stores information about a partition (for example, the last page of the partition) that processes must use when accessing that partition. Configure partition descriptors using number of open partitions.

The default value of partition spinlock ratio sets 1 spinlock for every 10 partition caches. Decreasing the value of partition spinlock ratio may have little impact on the performance of SAP ASE. The default setting is correct for most servers.

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