Note:
SAP ASE must be configured for process mode to use sp_engine. When SAP
ASE is configured for kernel mode, use create, alter,
and drop thread to configure memory pools.
Monitoring Engine Status
Before you bring an engine online or offline, check the status of the engines that are currently running. sysengines includes any of the following in the status column:
Starting and Stopping Engines with sp_engine
You can dynamically stop or start engines using sp_engine, which allows a you to reconfigure CPU resources as processing requirements fluctuate over time.