修改并发设置

sp_configure 'show advanced options', 1;
 
GO
 
RECONFIGURE WITH OVERRIDE;
 
GO
 
sp_configure 'max degree of parallelism', 16;--假如是8个(核)cpu
 
GO
 
RECONFIGURE WITH OVERRIDE;
 
GO
 
--max degree of parallelism 能最大限制的控制并行导致CPU不可用而造成的短查询的等待
 
sp_configure 'show advanced options', 1;
 
GO
 
RECONFIGURE WITH OVERRIDE;
 
GO
 
sp_configure 'cost threshold for parallelism', 2;--将此时间增加
 
GO
 
RECONFIGURE WITH OVERRIDE;
 
GO