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 for Me (Login required).

Search for additional results

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