Specific to Adaptive Server in threaded mode: Contains one row for each thread.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monThread are:
Name |
Datatype |
Description |
|---|---|---|
InstanceID |
tinyint |
ID of the instance within the cluster |
ThreadID |
int |
ID of the thread pool |
KTID |
int |
Internal kernel thread ID |
OSThreadID |
int |
ID of the operating system thread |
AltOSThreadID |
int |
Alternate operating system thread ID (on some platforms this may be a lightweight process (LWP) ID) |
ThreadPoolID |
int |
ID of the thread pool |
State |
varchar(30) |
Current state of the thread |
ThreadAffinity |
int |
CPU number to which the thread has affinity |
ThreadPoolName |
varchar(30) |
Name of the thread pool |
TaskRuns |
bigint |
Number of tasks this thread has run |
TotalTicks |
bigint |
Total number of ticks for this thread |
IdleTicks |
bigint |
Total number of ticks during which this thread was idle |
SleepTicks |
bigint |
Total number of ticks during which this thread was sleeping |
BusyTicks |
bigint |
Total number of ticks during which this thread was busy |
UserTime |
bigint |
Total amount of thread user CPU time, in miliseconds |
SystemTime |
bigint |
Total amount of thread system CPU time, in miliseconds |
MinorFaults |
bigint |
Total number of minor page faults. Value is 0 on Windows |
MajorFaults |
bigint |
Total number of major page faults. Value is 0 on Windows |
VoluntaryCtxtSwitches |
bigint |
Total number of voluntary operating system context switches. Value is 0 on Windows |
NonVoluntaryCtxtSwitches |
bigint |
Total number of nonvoluntary operating system context switches. Value is 0 on Windows |
