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
Нужно установить значение 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