Monitoring procedure cache performance

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”.