Set MaxDOP to match number of cores

Set-MaxDOP

EXEC sys.sp_configure N'show advanced options', 1 
GO
RECONFIGURE WITH OVERRIDE
GO

DECLARE @DOP INT

SELECT @DOP = CASE 
				WHEN cpu_count > 16 THEN 8
				else cpu_count / 2
			  END
FROM sys.dm_os_sys_info

EXEC sys.sp_configure N'max degree of parallelism', @DOP
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', 0 
GO
RECONFIGURE WITH OVERRIDE
GO