SQL Server Performance Forum – Threads Archive
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.