SQL Server Performance Forum – Threads Archive

max degree of parallelism Option

I have a high end server with 8 processor’s. I was wondering, what should be my max degree of parallelism option? can somebody provide some input and also is there a document which talks on this? Appreciated if someone please advice,
Thanks,
Cali

http://blogs.digineer.com/blogs/larar/archive/2006/11/13/maximum-degree-of-parallelism-and-hyperthreading.aspx
http://www.sqlservercentral.com/columnists/hroggero/managingmaxdegreeofparallelism.asp
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Thank you MohammedU.

]]>