A Common Misconception about MAXDOP

The misconception I’m trying to clear up is that it’s common to hear (or even say) that MAXDOP limits the number of processors that can be used—which simply isn’t true; MAXDOP constrains the number of threads per operator.

Please or Register to post comments.

What's Practical SQL Server?

Practical advice, insight, and help for core SQL Server considerations.

Contributors

Michael K. Campbell

Michael K. Campbell is a contributing editor for SQL Server Pro and Dev Pro and is an ASPInsider. Michael is the president of OverAchiever Productions, a consultancy dedicated to technical evangelism...
Blog Archive

Sponsored Introduction Continue on to (or wait seconds) ×