noclear is a new parameter to sp_sysmon. When the noclear option is included in the sp_sysmon, sp_sysmon does not zero out the monitor counters. As a result, data collected by other applications using the monitor counters at the same time are not be affected by the sp_sysmon report.
When used with the noclear parameter, sp_sysmon utilizes a temporary table. However, if space in the user’s default temporary database is limited, you may need to increase the size of the database to run sp_sysmon with noclear.
The report contents generated from sp_sysmon with or without the noclear should be the same. However, since the noclear parameter requires storing some data in a temporary table, the sp_sysmon report may show a small amount of additional server activity when run with the noclear parameter compared to execution without it.
A field called “Sample Mode” has been added to the sp_sysmon report header to indicate whether the report was generated using “No Clear” or “Reset Counters” mode. The report header indicates the sample start and end times with the labels “Sampling Started at” and “Sampling Ended at” when run with the noclear parameter. It displays “Statistics Cleared at” and “Statistics Sampled at” when run without the noclear parameter.
When noclear is used with a specific sample interval, for any parameter in the sp_sysmon, the command runs in noclear mode. If noclear is not specified, sp_sysmon clears the counters.
sp_sysmon interval [, noclear,[,section [, applmon]]]
Report usage without clearing the counters:
sp_sysmon “00:01:00”, kernel, noclear
sp_sysmon "00:01:00", noclear
You can use the noclear parameter
only when you specify a sample interval in sp_sysmon.
If you specify begin_sample or end_sample you
cannot use noclear.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
