Specifies the maximum number of statements listed inside the BEGIN PARALLEL WORK statement that the database server can execute in parallel at any time.
0 (The database server executes as many statements in parallel as it chooses).
|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.
The following example sets the max_parallel_statements option to four.
SET TEMPORARY OPTION max_parallel_statements = 4;