Using Recommendations for MAXDOP and Max Memory During Installation

  • iLearnSQL

    Say Hey Kid

    Points: 675

    Comments posted to this topic are about the item Using Recommendations for MAXDOP and Max Memory During Installation

  • Jeff Moden

    SSC Guru

    Points: 997349

    I'm not sure where the 70-30 recommendation actually came from but I have do disagree with it on large systems.  I can't believe it's not a total waste to give the operating system (for example) 30% of a half terabyte of RAM, which works out to giving the OS 150GB of RAM.  Of course, I could be wrong but someone would have to show me with some kind of real proof that 30% is a good idea on such a machine.

     

    --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".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

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

  • Jeff Moden

    SSC Guru

    Points: 997349

    p.s.  I don't know who left you a rating of "1" but it wasn't me.  I generally don't rate articles and I certainly wouldn't rate one so low without an explanation.  I think it's horribly selfish of someone to rate with a 1 or a 2 without explaining why because such low ratings do no one any good unless the person giving it explains why.

     

    --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".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

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

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

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