The system administrator can now manually modify the monitor counter usage count. When an application enables monitor counters, and does not 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 some of the monitor counters, by running the @@monitors_active global variable.
The usage counts for the spinlock_s and appl groups are reported by the dbcc resource command.
