Is there a SQL that I can use to determine the SPID that is the root cause of a 701 (not enough procedure cache)?
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.