• I'm seeing 32 CPU and are online when I run sys.dm_os_scheduler.

    So that means SQL server is able to use all the 32 available. I checked no affinity is configured so thats good to use 32 CPU's available.

    What is the ideal Maxdop value of 2 NUMA, 16 CPU each and no hyper threading ?

    Regards,

    Pavan S

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]