Fixed time intervals

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