monEngine

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 the SAP ASE server in process mode, modify the rate of yielding during idle periods using runnable process search count. If you are running the SAP ASE 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

Number of times the engine or disk controller (for process or threaded mode, respectively) checks for asynchronous disk I/O. In process mode, use i/o polling process count to modify the frequency of these checks.

DiskIOPolled

int

Counter, reset

Number of times the engine or disk controller (for process or threaded mode, respectively) polls for completion of outstanding asynchronous disk I/O, which occurs when disk I/O checks indicate that asynchronous I/O has been posted, but is not yet complete.

DiskIOCompleted

int

Counter, reset

Number of asynchronous disk I/Os completed when the engine or disk controller (for process or threaded mode, respectively) polls 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 the SAP ASE 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.