To invoke sp_sysmon, use isql to execute:
sp_sysmon interval [, section [, applmon]]
interval must be in the form “hh:mm:ss”. For example, to run sp_sysmon for 10 minutes, use:
sp_sysmon "00:10:00"
To print only the “Data Cache Management” section of the report, use:
sp_sysmon "00:10:00", dcache
For information on the applmon parameter, see “Specifying the application detail parameter”.
