monEngine

Description

Provides statistics regarding Adaptive Server engines.

Enable the enable monitoring configuration parameter for this monitoring table to collect data.

Columns

Name	Datatype	Attributes	Description
EngineNumber	smallint		Number of the engine.
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.
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. modify the rate of yielding during idle periods using runnable process search count.
Connections	int	Counter	Number of connections this engine handles.
DiskIOChecks	int	Counter, reset	Number of times the engine checked for asynchronous disk I/O. Modify the frequency of these checks with i/o polling process count.
DiskIOPolled	int	Counter, reset	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	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.