Skip to Content
0
Former Member
Aug 01, 2014 at 12:34 PM

Error 701, not enough procedure cache (*Urgent*)

1717 Views

Hi All,

Is there a SQL that I can use to determine the SPID that is the root cause of a 701 (not enough procedure cache)?

Additional information:

This is happening in 2 servers; 15G memory with 2G procedure cache and 10G memory with 1.25G procedure cache.

Environment: Sun Solaris 10 running ASE 15.0.3 ESD#4

Monitoring has been enabled.

Sybase recommends either increasing the procedure cache or running dbcc proc_cache(free_unused) periodically.

I would rather identify the process causing it or the configuration setting in these 2 environment that is causing this to happen.

Thanks in advance.

Anil