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?
  • 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) 15.7 and 16.0 for Business Suite
  • SAP Netweaver (NW) 7.4

Product

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

Keywords

"SQL Cache Hit Ratio", "E2E Alerting" , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.