Max Degree of Parallelism

The max degree of parallelism (MAXDOP) configuration option limits how many processors can be used during the execution of a query. Having the setting too low can limit SQL Server's ability to benefit from running queries over multiple processors, but having it set too high can cause problems with CPU contention. Other factors include MAXDOP set at a database level, resource governors, and the MAXDOP query hint.

Suggested Action

💡 Select 'Suggested Script' for an automatically generated script using the guidelines from Microsoft.

Review the max degree of parallelism setting.

How to Change the Max Degree of Parallelism for SQL Server (Database Level)

USE [WhippetWorks]
GO
ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 4;
GO

How to Change the Max Degree of Parallelism for SQL Server (System-Wide)

EXEC sys.sp_configure N'show advanced options', N'1'  RECONFIGURE
GO
EXEC sys.sp_configure N'max degree of parallelism', N'4'
GO
RECONFIGURE
GO

Further Reading

Configure the max degree of parallelism Server Configuration Option | Microsoft Docs