number of Q engines at startup

This is an integer option that controls the number of Adaptive Server Q engines that are automatically started when Adaptive Server starts. For example:

sp_configure "number of Q engines at startup", 4

Valid values are:


max native threads per engine

A Q engine uses operating system native threads. The max native threads per engine configuration parameter controls the maximum number of native threads that a Q engine uses. In this example, the procedure limits every Q engine to a maximum of 100 native threads:

sp_configure 'max native threads per engine', 100

The parameter has the following values:

If there are more messaging sessions than there are native threads configured, the messaging operation blocks and waits until a native thread is released.