sp_sysmon supports the new performance features in release 11.5, including the addition of these new sections in the sp_sysmon report:
Application Queue Management
Asynchronous Prefetch Usage
Metadata Cache Management
Monitor Access to Executing SQL
Parallel Query Management
Worker Process Management
The syntax for sp_sysmon has been changed:
You can specify the interval using the form “hh:mm:ss”.
You can use the begin_sample argument to start sp_sysmon which continues to monitor until you use end_sample to print the report.
You can print only one section of the report at a time. This example specifies an interval of 15 minutes and prints only the Data Cache Management section:
sp_sysmon "00:15:00, dcache
See Chapter 24, “Monitoring Performance with sp_sysmon,” in the Performance and Tuning Guide for more information.
