====== SQL: устанавливаем параметр max degree of parallelism ======

===== Как проверить значение установленного параметра 'max degree of parallelism' =====

<code>
sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'max degree of parallelism'
</code>

===== Как задать значение =====

Устанавливаем значение 4:
<code>
sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'max degree', 4
go
sp_configure 'show advanced',0
reconfigure with override
</code>

===== Как отключить параметр 'max degree of parallelism' =====

Нужно установить значение 1:
<code>
sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'max degree', 1
go
</code>

===== Доп. инфо =====

If max degree of parallelism = 0, you may want to do one of the following: 
· Turn off parallelism by setting max degree of parallelism to 1 
· Limit parallelism by setting max degree of parallelism to less than the total number of CPUs. For example, if you have 8 procedures, set max degree of parallelism to 4 or less