Specific to the SAP ASE server in threaded mode: Contains one row for each thread pool.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monThreadPool are:
Name |
Datatype |
Description |
|---|---|---|
ThreadPoolID |
int |
ID of the thread pool |
Size |
int |
Number of threads in the thread pool |
TargetSize |
int |
Requested size (differs from Size only when you change pool sizes) |
Tasks |
int |
Number of tasks associated with the thread pool |
ThreadPoolName |
varchar(30) |
Name of the thread pool |
ThreadPoolDescription |
varchar(255) |
(Optional) description of the thread pool |
Type |
varchar(30) |
Thread pool type, Engine (multiplexed) or Run to Completion (RTC) |
IdleTimeout |
int |
Amount of time, in microseconds, that threads in this pool search for runnable tasks before idling |