Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

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

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.