Changes to sp_sysmon

Adaptive Server version 15.0.1 changes the default behavior of sp_sysmon.

In Adaptive Server version 15.0.1 and later, sp_sysmon does not clear the monitor counters. You no longer have to specify the noclear option to prevent sp_sysmon from clearing the monitor counters. This is the default behavior.

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.

However, 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.

NoteFor information about the noclear option that was introduced in Adaptive Server version 12.5.3, see Chapter 43, “Monitor Counters and sp_sysmon.”