MAXDOP - Multiple Instances question

• David_104

  SSC Enthusiast

  Points: 141

  More actions

  August 3, 2011 at 8:19 am

  #241689

  Hello,

  When configuring a SQL Server 2008 R2 server with 5 instances is there a best practice for configuration MAXDOP across all instances with 8 cores available in total? I would appreciate any links or guides.

  My initial thoughts are that I will configure the box to be set at MAXDOP = 2 for each instance so I have uniform configuration without causing resource conflicts, but what could the impact be if we have varying MAXDOP settings for the instances?

  Articles reviewed:

  http://blogs.msdn.com/b/cindygross/archive/2011/01/28/the-ins-and-outs-of-maxdop.aspx

  Thanks in advance!

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 3, 2011 at 8:24 am

  #1363088

  What happens if 1 report needs to run a massive query and can only use 2 cores instead of 8 while the 6 other cores are doing nothing?

  This is more a matter of understanding your servers and what they need to be able to do.