max_parallel_statements option

Specifies the maximum number of statements listed inside the BEGIN PARALLEL WORK statement that the database server can execute in parallel at any time.

Allowed values

Integer

Default

0 (The database server executes as many statements in parallel as it chooses).

Scope

	PUBLIC role	For current user	For other users
Allowed to set permanently?	Yes, with SET ANY PUBLIC OPTION	Yes	Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily?	Yes, with SET ANY PUBLIC OPTION	Yes (current connection only)	No

Setting the max_parallel_statements option to 1 disables the parallel execution of the statements inside a BEGIN PARALLEL WORK statement.

The max_parallel_statements option respects the settings of the -gtc and -gta database server options and the ProcessorAffinity option of the sa_server_option system procedure.

Example

The following example sets the max_parallel_statements option to four.

SET TEMPORARY OPTION max_parallel_statements = 4;