In this article, I’m going to delve into the topics of MAXDOP and cost threshold for parallelism.
I’m writing it for two reasons:
- There was a recent thread on SQL Server settings on the NAVUG list. Some of the information was good. But much of it was expressed in terms of “Well, I heard…,” which makes me nervous. You should have a basic understanding of what various settings do before you start taking anyone’s advice.