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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.