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
Comments