February 9, 2016 at 4:25 pm
Hi.
I found that in one of the servers the max dop value is set to 1 but in the server it has 8 cores.
Is this fine to have 8 as the MAXDOP value is set to 1 or can it hurt the performance?
Please suggest.
Thanks.
February 9, 2016 at 6:14 pm
SQL-DBA-01 (2/9/2016)
Hi.I found that in one of the servers the max dop value is set to 1 but in the server it has 8 cores.
Is this fine to have 8 as the MAXDOP value is set to 1 or can it hurt the performance?
Please suggest.
This isn't a simple yes or no question. See Paul's comments on MAXDOP at http://www.sqlskills.com/blogs/paul/maxdop-configuration-survey-results/.
February 9, 2016 at 9:33 pm
It depends. There are few applications like BizTalk, Sharepoint which have a recommended value of MAXDOP 1.
February 10, 2016 at 4:54 am
On most systems, most of the time, I recommend letting parallel execution occur. Instead of attempting to control it with maxdop, change the Cost Threshold for Parallelism. The default value of 5 is almost always incorrect.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply