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