There are two ways to use sp_sysmon:
Using a fixed time interval to provide a sample for a specified number of minutes
Using the begin_sample and end_sample parameters to start and stop sampling
You can also tailor the output to provide the information you need:
You can print the entire report.
You can print just one section of the report, such as “Cache Management” or “Lock Management.”
The Cache Wizard section is a special
section of the report. You need to specify the section for Cache
Wizard to get output on it. See “Output”
You can include application-level detailed reporting for named applications (such as isql, bcp, or any named application) and for combinations of named applications and user names. (The default is to omit this section.)
