Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Max Degree of Parallelism

Posted on 2011-05-06
Medium Priority
Last Modified: 2012-05-11
I have a server thats has 4 quad core multi threaded processors, and I currently have the degree of parallelism set to 4; however I haven't seen a performance improvement.  Should I increase the max degree of parallelism?
Question by:nitayalevette

Accepted Solution

rocky_lotus_newbie earned 500 total points
ID: 35707053
Below is a good blog giving on MAXDOP setting:


LVL 21

Expert Comment

by:Alpesh Patel
ID: 35711195
SQL SErver 2008 Support only 2 CPU.

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question