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.