SAP Knowledge Base Article - Preview

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

Symptom

  • How to estimate / calculate the statement cache size needed for a given ASE running for SAP Business Suite applications?
  • 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?


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.x for Business Suite
  • SAP Netweaver (NW) 7.40 or higher

Product

SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

"SQL Cache Hit Ratio", "E2E Alerting", dbacockpit, "statement cache size" , 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.