3392807 - Procedure Cache Management - SAP ASE

• The procedure cache size and usage need to be monitored:

• • Slow execution of stored procedures is observed.

• • Message 701 errors are often seen, indicating that the procedure cache memory has been exhausted.

• • The size of the procedure cache was increased, but overall Adaptive Server performance has been degraded.

• • This is deemed highly relevant for any environment where stored procedures are used.

• • Even if stored procedures are not used frequently, server performance may be sped up by resizing the procedure cache.

SAP Adaptive Server Enterprise (ASE)

sp_sysmon, monProcedureCache, monProcedureCacheMemoryUsage, removal, request, recompilation, size, 701, 703, error, high Procedure Removals; There is not enough procedure cache to run this procedure , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To