SQL Server Performance Forum – Threads Archive

MAXDOP

Hello,
I have a SQL 2K server w/ 4 processors. I read somewhere that its best to set the MAXDOP option to n-1. For example, in my case the max degree of parallelism will be set to 3. Is that true? Right now, my max degree of parallelism is set to 0.

---

Leave this option to default so that SQL Server will process the query parellely or serialy, unless you experience any problem with that. I think 0 is the default value for max degree of parallelism option. Check BOL, I don’t remember exactly.

---

]]>