Provides information regarding the overall state of Adaptive Server. No configuration options are necessary for monState.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
LockWaitThreshod |
int |
Time (in seconds) that processes must have waited for locks in order to be reported |
|
LockWaits |
int |
Number of processes that have waited longer than LockWaitThreshold seconds |
|
StartDate |
datetime |
Date and time that Adaptive Server was started |
|
DaysRunning |
int |
Number of days Adaptive Server has been running |
|
CountersCleared |
datetime |
Date and time the monitor counters were last cleared |
|
CheckPoints |
int |
Reports whether any checkpoint is currently running |
|
NumDeadlocks |
int |
counter |
Total number of deadlocks that have occurred |
Diagnostic Dumps |
int |
Reports whether sybmon is performing a shared memory dump |
|
Connections |
int |
Number of active inbound connections |
|
Max Recovery |
int |
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 |
