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