Provides statistics regarding Adaptive Server engines.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monEngine are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
EngineNumber |
smallint |
Number of the engine. |
|
ThreadID |
int |
ID of the thread associated with the engine. |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
CurrentKPID |
smallint |
Kernel process identifier (kpid) for the currently executing process. |
|
PreviousKPID |
int |
kpid 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. |
IOCPUTime |
int4 |
The amount of time, in seconds, the engine has been waiting for issued IOs to complete. |
|
IdleCPUTime |
int |
Counter, reset |
Time, in seconds, the engine has been in idle spin mode. |
Yields |
int |
Counter, reset |
Number of times this engine yielded to the operating system. If you are running Adaptive Server in process mode, modify the rate of yielding during idle periods using runnable process search count. If you are running Adaptive Server in threaded mode, modify the rate of yielding during idle periods with alter thread pool .. idle timeout. |
Connections |
int |
Counter |
Number of connections this engine handles. |
DiskIOChecks |
int |
Counter, reset |
(Process mode only) Number of times the engine checked for asynchronous disk I/O. Modify the frequency of these checks with i/o polling process count. Does not apply when a thread is used for I/O completion polling. |
DiskIOPolled |
int |
Counter, reset |
(Process mode only) Number of times the engine polled for completion of outstanding asynchronous disk I/O. The polling occurs whenever disk I/O checks indicate that asynchronous I/O has been posted and is not yet complete. |
DiskIOCompleted |
int |
Counter, reset |
(Process mode only) Number of asynchronous disk I/Os completed when the engine polled for outstanding asynchronous disk I/O. |
MaxOutstandingIOs |
int |
Current number of I/O requests initiated by this engine that are not completed. |
|
ProcessesAffinitied |
int |
Number of processes associated with this engine. |
|
ContextSwitches |
int |
Counter, reset |
Number of context switches. |
HkgcMaxQSize |
int |
Maximum number of items Adaptive Server can queue for housekeeper garbage collection in this engine. |
|
HkgcPendingItems |
int |
Number of items yet to be collected by housekeeper garbage collector on this engine. |
|
HkgcHWMItems |
int |
Maximum number of pending items queued for housekeeper garbage collector at any instant since server started. |
|
HkgcOverflows |
int |
Number of items that could not be queued to housekeeper garbage collector due to queue overflows. |
|
Status |
varchar(20) |
Null |
Status of the engine (online, offline, and so on). |
Starttime |
datetime |
Null |
Date that the engine came online. |
StopTime |
datetime |
Date that the engine went offline. |
|
AffinitiedToCPU |
int |
Null |
Number of the CPU to which the engine is affinitied. |
OSPID |
int |
Null |
Identifier for the operating system process executing the engine. |
