Changes to stored procedures  New function

Chapter 15: Changes to Stored Procedures, Functions, and Commands

sp_sysmon

When the noclear option is included in the sp_sysmon, sp_sysmon does not zero out the monitor counters.

Syntax

sp_sysmon interval [, noclear,[,section  [, applmon]]]

Example

Report usage without clearing the counters:

sp_sysmon “00:01:00”, kernel, noclear
sp_sysmon "00:01:00", noclear

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

See Chapter 14, “Monitor Counters and sp_sysmon” for more information.





Copyright © 2005. Sybase Inc. All rights reserved. New function

View this book as PDF