Provides information regarding the overall state of Adaptive Server.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monState are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
LockWaitThreshold |
int |
Time (in seconds) that a process must
wait for a lock before it is counted as blocked and reported in
the LockWaits column. The default value for LockWaitThreshold is
5 seconds. The default is used if you do not specify a value in
the where clause of the query (for example |
|
LockWaits |
int |
Number of process that have waiting for a lock longer than the value of LockWaitThreshold. |
|
DaysRunning |
int |
Number of days Adaptive Server has been running. |
|
CheckPoints |
int |
Specifies if any checkpoint is currently running. |
|
NumDeadlocks |
int |
Counter |
Total number of deadlocks that have occurred. |
Diagnostic Dumps |
int |
Specifies if a shared memory dump is currently in progress for this server. |
|
Connections |
int |
Number of active inbound connections. |
|
MaxRecovery |
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 the recovery interval in minutes configuration option. |
|
Transactions |
int4 |
Number of transactions run, server-wide. |
|
StartDate |
datetime |
Date and time Adaptive Server was started. |
|
CountersCleared |
datetime |
Date and time the monitor counters were last cleared. |