kernel mode determines the mode the SAP ASE kernel uses, threaded or process.
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 |
In threaded mode, SAP ASE uses operating system threads to support SAP ASE engines and specialized tasks. In this mode, SAP ASE is a single process running on the operating system. In process mode, SAP ASE uses individual processes to support SAP ASE engines. In this mode, each engine is a distinct process running on the operating system. The process mode is the same kernel used by SAP ASE versions earlier than 15.7.
On Windows, SAP ASE supports only threaded kernel mode.
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.
SAP assumes you use threaded mode in your production server, and includes process mode for backward compatibilty. Process mode may not support features for SAP ASE 15.7 and later.
See System Administration Guide: Volume 2 > Managing Multiprocessor Servers.