• salimdallal - Wednesday, August 30, 2017 1:47 PM

    I don't have much experience there but i'll give do some research on this value. But from your experience have setting Max DOP caused an increase in average CPU consumption of SQL machine?

    Directly? No, not really. However, changing the value will result in the optimizer making different choices since that value is taken into account. I haven't seen a radical set of changes from changing this value, but I can envision how it might happen. Do you have before & after execution plans?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning