The System Administrator can now manually modify monitor counter usage count. When an application enables monitor counters, then fails to disable them before logging off Adaptive Server, the System Administrator can use these commands to terminate monitor counter data collection:
dbcc monitor (increment, <group name>)
dbcc monitor (decrement, <group name>)
dbcc monitor (reset, <group name>)
Where <group name> can be one of the following:
‘all’
spinlock_s
appl
increment and decrement increase and decrease usage counts for the monitor counters in the specified group by 1. reset sets the usage count for the monitor counters in the specified group to zero. This turns off collection of monitoring data for this group.
You can determine the usage count for all, which comprises most of the monitor counters, by selecting the @@monitors_active global variable.
The usage counts for the spinlock_s and appl groups are reported by the dbcc resource command.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
