New commands are now available to allow the System Administrator to manually modify the monitor counter usage count. Under normal conditions it would not be necessary for the System Administrator to use these commands. However, in cases where an application enables the monitor counters, then fails to disable them before logging off Adaptive Server, the System Administrator needs to use these commands to terminate monitor counter data collection.
The new DBCC commands are:
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
The increment and decrement commands increase and decrease the usage counts for the monitor counters in the specified group by 1. The reset command sets the usage count for the monitor counters in the specified group to zero. This will turn off collection of monitoring data for this group.
The usage count for the all group, which comprises most of the monitor counters, can be determined by selecting the @@monitors_active global variable.
The usage counts for the spinlock_s and appl groups are reported by the dbcc resource command.
See “Monitor counter concurrency” for more information.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
