MAXDOP in SQL Server

Setting MAXDOP = 1 in OLTP environment has been known to reduce total waits (25%) and CPU utilization (30%). MAXDOP = 0 is the best option for read-only/OLAP environments.

 

Thanks again to Jimmy May for this tip.  Details at

http://blogs.msdn.com/jimmymay/archive/2008/12/02/case-study-part-2-cxpacket-wait-stats-max-degree-of-parallelism-option-suppressing-query-parallelism-eliminated-cxpacket-waits-liberated-30-of-cpu.aspx