2122156 - How to size Procedure Cache? - SAP ASE

Symptom

ASE procedure cache may be insufficient to meet current workload requirements
What is the best practices to determine how large procedure cache should be in ASE?
After upgrading to next major version, should I increase procedure cache?
In sp_monitorconfig "procedure cache size" shows 100% used

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

proc cache size, Size of largest plan, size nested procedures, additional memory, query optimization, sp_monitorconfig , KBA , sp_monitorconfig , 701 , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.