Provides statistics regarding Adaptive Server engines. Requires the enable monitoring configuration parameter to be enabled.
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
Engine Number |
smallint |
Number of the Adaptive Server engine |
|
Starttime |
datetime |
Date that the engine came online |
|
StopTime |
datetime |
Date that the engine went offline |
|
CurrentKPID |
int |
Kernel process identifier for the currently executing process. |
|
PreviousKPID |
int |
Kernel process identifier for the previously executing process |
|
CPUTime |
int |
counter, reset |
Total time (in seconds) the engine has been running |
SystemCPUTime |
int |
counter, reset |
Time (in seconds) the engine has been executing system database services |
UserCPUTime |
int |
counter, reset |
Time (in seconds) the engine has been executing user commands |
IdleCPUTime |
int |
counter, reset |
Time (in seconds) the engine has been in idle spin mode |
ContextSwitches |
int |
counter, reset |
Number of context switches |
Connections |
int |
counter |
Number of connections handled |
ProcessesAffinitied |
int |
Number of processes that have been affinitied to this engine |
|
Status |
varchar(30) |
null |
Status of the engine (online, offline, and so on) |
AffinitiedToCPU |
int |
null |
The number of the CPU that the engine is affinitied to |