SAP Knowledge Base Article - Preview

2153332 - How is the statement cache hit ratio calculated - SAP ASE for Business Suite


  • How to estimate / calculate the statement cache size needed for a given ASE?
  • What are the factors to consider when tuning a statement cache?
  • What is the formula to calculate the statement cache hit ratio?
  • What is the recommended hit ratio for a statement cache?



  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Netweaver (NW) 7.4


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4 ; Sybase Adaptive Server Enterprise 15.5


"SQL Cache Hit Ratio", "E2E Alerting" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.