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:
Minimum value is 0.
Default value is 0.
Maximum value must be less than max online Q engines.
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:
Minimum value is 50
Maximum value is 1000
Default value is 50
If there are more messaging sessions than there are native threads configured, the messaging operation blocks and waits until a native thread is released.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
