Post reply

does max dop query hint over write max dop setting at server level?

  • May 31, 2011 at 7:44 pm

    #237192

    I always get confused when trying to understand max dop :(. I was so lost after talking to Microsoft engineer today. Can someone please clarify my two questions.

    i) I am using 8 cpu , 64 bit sql 2005 stnd edition. if i have my max dop set to 1 at server level does it mean that all my transaction/processes will use ONLY 1 CPU? Does it mean that my sql server is running at 1 CPU only?

    ii) if i have my max dop set to 1 at server level and if i use max dop query hint which one actually takes in effect at run time?

    Thanks

  • May 31, 2011 at 8:53 pm

    #1332345

    Lookup MAXDOP in Books Online. The answer is there.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply