SAP Knowledge Base Article - Preview

2037434 - Error 701 "There is not enough procedure cache to run this procedure ..." - SAP ASE

Symptom

  • ASE is regularly hitting out of procedure cache errors - how to resolve ?
Error 701 Severity 17 "There is not enough procedure cache to run  this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure  SQL Server with more procedure cache."
  • dbcc proc_cache(free_unused) avoids the issue, but should ASE not free up unused plans ?

 


Read more...

Environment

SAP Sybase Adaptive Server Enterprise (ASE) All Versions

Product

Sybase Adaptive Server Enterprise all versions

Keywords

procedure cache, error 701,unused plan , KBA , 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 ONE Support launchpad (Login required).

Search for additional results

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