MAXTOTALACTIVETRANSACTIONS

Controls the total number of transactions, including read-only and update transactions, that are allowed at the same time. When the limits are exceeded, the later arriving transactions must wait for others to finish.

Syntax

MAXTOTALACTIVETRANSACTIONS n

Where n the number of simultaneous active transactions allowed. The default is the same as the number of cores on the server machine.

Description

Each allotted server thread may create child threads for tasks such as parallel calculation, parallel data load or export, and parallel restructuring. If the total number of running threads becomes too high, threads may lose efficiency in contending for server resources. Use this setting to help control the number of simultaneous transactions.

Use this setting with MAXACTIVEUPDATETRANSACTIONS. MAXTOTALACTIVETRANSACTIONS should be no larger than the number of server threads, and MAXACTIVEUPDATETRANSACTIONS should be no larger than MAXTOTALACTIVETRANSACTIONS.

Example

MAXTOTALACTIVETRANSACTIONS 4

See Also

MAXACTIVEUPDATETRANSACTIONS

SERVERTHREADS