Maxdop unabled

Maxdop unabled.

Last updated: 19 September 2016

Warning: Review and test in a non-production environment before running.

Back to results

SELECT * FROM sys.Configurations

sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE;
GO

sp_configure 'max degree of parallelism', 32;
GO
RECONFIGURE WITH OVERRIDE;
GO