SQL Server CPU MAXDOP Setting

Maxdop - 1, means no parallelism

Maxdop - 0 (Default), Means SQL Server can aggressively use all the available processor to execute the query.

Maxdop - 8, Use max of 8 logical processors to execute the query.

--Set CPU MAXDOP setting

sp_configure 'show advanced options',1

go

reconfigure

go

sp_configure 'max degree of parallelism',0

go

reconfigure