2513826 - How the number of hash spinlocks is calculated - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2513826 - How the number of hash spinlocks is calculated - SAP ASE

Symptom

  • All versions of ASE 15.7 and ASE 16.0  Reference Manual: Configuration Parameters > lock spinlock ratio read:

The SAP ASE default value for lock spinlock ratio is 85. With lock hashtable size set to the default value of 2048, the default spinlock ratio defines 26 spinlocks for the lock hash table

  • How is the number of hash spinlocks calculated?
  • Should it be 24 spinlocks instead of 26 spinlocks?   Like in (lock hashtable size) /(lock spinlock ratio) = 2048 / 85 = 24.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

engines, bucket, estimate , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.