The idle timout parameter for create thread pool and alter thread pool determines the amount of time, in microseconds, a thread in this pool looks for work before going to sleep. You can set idle timout for engine pools only, not for RTC pools. See “Setting Configuration Parameters” in the System Administration Guide: Volume 1.
The default for idle timout is 100 microseconds. However, Adaptive Server may not precisely honor the timeout period, especially at lower values (lower than 100).
Once you set the value for idle timeout, Adaptive Server registers the value in the configuration file under the Thread Pool heading:
[Thread Pool:new_pool] number of threads = 1 idle timeout = 500
Setting idle timeout to -1 prevents the engines from yielding. At this setting, the engines consume 100% of the CPU.
The idle timeout parameter replaces
the runnable process search count configuration
parameter used in versions of Adaptive Server earlier than 15.7. idle
timeout is available for threaded mode only. However, runnable
process search count remains available for process mode.
