Summary information |
|
---|---|
Default value |
threaded |
Range of values |
threaded or process |
Status |
Static |
Display level |
Basic |
Required role |
System administrator |
Configuration group |
SQL Server Administration |
kernel mode determines the mode the Adaptive Server kernel uses, threaded or process. In threaded mode, Adaptive Server uses operating system threads to support Adaptive Server engines and specialized tasks. In this mode, Adaptive Server is a single process running on the operating system. In process mode, Adaptive Server uses individual processes to support Adaptive Server engines. In this mode, each engine is a distinct process running on the operating system. The process mode is the same kernel used by Adaptive Server versions earlier than 15.7.
Adaptive Server supports only threaded kernel mode on the Windows platform.
The values for kernel mode are character data, so you must use 0 as a placeholder for the second sp_configure parameter, which must be numeric, and specify threaded or process as the third parameter. See “Unit specification using sp_configure”.
Sybase assumes you use threaded mode in your production server, and includes process mode for backward compatibilty. Process mode may not support features for Adaptive Server 15.7 and later.
See Chapter 5, “Managing Multiprocessor Servers,” in the System Administration Guide: Volume 2.