Kernel Modes

By default, SAP ASE starts in threaded mode, appearing as a single process on your operating system, and using native operating system threads for parallelism. By default, SAP ASE handles I/O with native threads.

In process mode, SAP ASE appears as multiple processes on the operating system.

Process mode may not support features available in later versions of SAP ASE. SAP intends for you to use process mode as a fallback if you experience problems running in threaded mode.

Note: For architecture reasons, process mode is not available on the Windows platform. Earlier versions of SAP ASE on Windows also used a multithreaded, single-process kernel.

To determine the current mode of SAP ASE, use:

select @@kernelmode

--------------------------------------
threaded