max online engines

Summary information

Default value

1

Range of values

1–128

Status

Static

Display level

Intermediate

Required role

System Administrator

The role of max online engines is to set a high value of engines to be taken online at any one time in an SMP environment. It does not take the number of CPUs available at start-up into account, and allows users to add CPUs at a later date.

max engines online specifies the maximum number of Adaptive Server engines that can be online at any one time in an SMP environment. See Chapter 20, “Managing Multiprocessor Servers,” for a detailed discussion of how to set this parameter for your SMP environment.

At start-up, Adaptive Server starts with a single engine and completes its initialization, including recovery of all databases. Its final task is to allocate additional server engines. Each engine accesses common data structures in shared memory.

When tuning the max engines online parameter:

See “Taking engines offline with dbcc engine” for information on using dbcc engine. See Chapter 4, “Using Engines and CPUs” in the Performance and Tuning: Basics for more information on performance and engine tuning.