sqlserver 修改max degree of parallelism

查询max degree of parallelism 当前值：

SELECT value_in_use  FROM sys.configurations WHERE name = 'max degree of parallelism'

 

修改为8：

sp_configure 'show advanced options',1
go
RECONFIGURE WITH OVERRIDE;  
go
sp_configure 'max degree of parallelism',8
go
RECONFIGURE WITH OVERRIDE;  
go
sp_configure 'max degree of parallelism'
go

 

 

 

参考：https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15&viewFallbackFrom=sql-server-previousversions