sp_sysmon reports on stored procedure executions and the number of times that stored procedures need to be read from disk.
For more information, see “Procedure cache management” on page 96 in the book Performance and Tuning: Monitoring and Analyzing for Performance.
