Adaptive Server State

The metrics in this category provide information regarding the overall state of Adaptive Server.

Collection Frequency - 30 minutes

Table 3-2 Adaptive Server State Metrics

Metric	Description	Default Warning Threshold	Default Critical Threshold	Alert Text
Number of processes waited longer than lock wait threshold	Number of processes that have waited longer than LockWaitThreshold seconds.	Not Defined	Not Defined	The total number of processes waited longer than lock wait threshold are %LockWaits%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.
Number of deadlocks occured since last collection	The number of deadlocks that have occured since the last collection.	Not Defined	Not Defined	The total total number of occured deadlocks are %NumDeadlocks%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.

Table 3-3 Adaptive Server State Metrics

Metric	Description
Checkpoints	Reports whether any checkpoint is currently running.
Number of active inbound connections	Number of active inbound connections.
Monitoring counters clearing date	Date and time the monitor counters were last cleared.
Number days Adaptive Server has been running	Number of days Adaptive Server has been running
Diagnostic Dumps	Reports whether sybmon is performing a shared memory dump
Lock wait threshold (seconds)	Time (in seconds) that processes must have waited for locks in order to be reported.
Max Recovery time per database (minutes)	The maximum time (in minutes), per database, that Adaptive Server uses to complete its recovery procedures in case of a system failure. Also, the current Run Value for recovery interval in minutes.
Total number of occurred deadlocks	Total number of deadlocks that have occurred.
Adaptive Server started date	Date and time that Adaptive Server was started.