sp_sysmon noclear option  New dbcc commands

Chapter 14: Monitor Counters and sp_sysmon

Monitor counter concurrency

Adaptive Server version 12.5.3 tracks the number of applications using the monitor counters. Adaptive Server does not disable or stop data collection by the monitor counters as long as one or more applications are known to be using them. This allows applications such as sp_sysmon and the Monitor Server to operate concurrently.

This change does not require any modifications on applications using monitor counters. Adaptive Server tracks the number of different applications or user connections where the monitor counters have been enabled or disabled. The monitor counters are disabled only when all connections have disabled them.

The monitor counter usage count is not automatically decremented when an application that enabled the monitor counters logs out of Adaptive Server. This means that, if an application enables the monitor counters and does not disable them before logging out, the usage count continues to reflect the same number of users as it did prior to the application logging out. This can be corrected by using new dbcc commands described in the following section.





Copyright © 2005. Sybase Inc. All rights reserved. New dbcc commands

View this book as PDF