Use the max parallel degree configuration parameter to configure the maximum amount of parallelism for a query. This parameter determines the maximum number of threads Adaptive Server uses when processing a given query. For example, to set max parallel degree to 10, enter:
sp_configure "max parallel degree", 10
Unlike versions of Adaptive Server earlier than 15.0, this parameter’s value is not entirely enforced by the query optimizer. A complete enforcement process is expensive in terms of optimization time. Adaptive Server comes close to the desired setting of max parallel degree and exceeds it only for semantic reasons.
