This chapter describes the monitoring tables in alphabetical order.
The Attributes column provides information about how Adaptive Server manages the column. An Attribute value of:
“Counter” indicates value in this column may wrap, or become zero and start incrementing again, because the value exceeds the maximum possible value of 231. Adaptive Server resets the monitor counters when you run sp_sysmon without the noclear option. In Adaptive Server version 15.0.1 and later, the noclear option is, by default, included as a sp_sysmon parameter. In versions earlier than 15.0.1, you must specify noclear to prevent Adaptive Server from resetting the monitor counters.
Resetting monitor counters may skew your results if you run sp_sysmon on the same Adaptive Server on which you are using the monitoring tables.
“Null” indicates the column value may be null.
“Reset” indicates the column is reset when you run sp_sysmon in a manner that causes it to clear the monitoring counters (see Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon).
