Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Hi I've a server with 2 physical processors with 8 cores each.

Looking through Management Studio Shows me a tree with NUMA 0 and NUMA 1 and inside 8 childs.

The current maxdop is on 0, should I set a different maxdop for the server? If so this should be 2 or 16? Should MAXDOP be based on physical or logical processors count?

Thanks, any help is appreciated. Gabriel

share|improve this question
    
MAXDOP = 0 means auto-detect (i.e., use the maximum available). – Jon Seigel Mar 5 '11 at 21:49

This article from Microsoft has some good general guidelines for setting MAXDOP. In general, you'd want to base this off of logical processor count, and you'd want to set it to 8 for a system with 8 or more processors. We have a system with 64 logical processors, and we see extreme performance problems when this is set to 0. We have it at 8, and it seems to work pretty well. Your best bet is to experiment with a few settings while under your normal load and see how it performs.

share|improve this answer

MAXDOP should be zero unless you have a clear, defined issue caused by the default setting.

I'd do nothing unless I had to, most likely under direction of MS PSS.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.