The behavior for sp_sysmon has changed so that you no longer have to specify the noclear option to prevent sp_sysmon from clearing the monitor counters. The noclear option is now the default behavior for sp_sysmon when you specify a sample interval.
If you run sp_sysmon using the begin_sample and end_sample options to begin and end the sample period, sp_sysmon always clears the monitor counters. Adaptive Server issues an error message if you run sp_sysmon with begin_sample or end_sample and the noclear option.
If you need to clear the monitor counters, use sp_sysmon with the clear option. For compatibility reasons, Adaptive Server accepts the noclear option as a valid parameter, but it does not affect the behavior of sp_sysmon.
