Содержание

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

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

sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'max degree of parallelism'

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

Устанавливаем значение 4:

sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'max degree', 4
go
sp_configure 'show advanced',0
reconfigure with override

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

Нужно установить значение 1:

sp_configure 'show advanced',1
reconfigure with override
go
sp_configure 'max degree', 1
go

Доп. инфо

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