Monitoring procedure cache performance

sp_sysmon reports on stored procedure executions and the number of times that stored procedures must be read from disk.

See Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.

If there is not enough memory to load another query tree or plan, or if the maximum number of compiled objects is already in use, Adaptive Server reports Error 701.