Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sadan Kumar Budde TempDB Database On a Local Disk for an FCI RE: TempDB Database On a Local Disk for an FCI

  • March 8, 2017 at 7:51 am

    #1932308

    I've found that putting TempDB on SSDs normally doesn't help much.  Good code doesn't need it and bad code might see a 2X-5X improvement, which is still a pitiful improvement compared to finding the performance challenged code that uses too much TempDB and fixing it.  Fixing such code can easily realized a 30-60X improvement with a 1000X improvement not being uncommon and it doesn't take much to accomplish such fixes.

    Even MPP systems (which usually require a tweek of the code to take advantage of it) only advertise a 33X improvement.

    If you want performance, performance is in the code.  Bite the bullet and fix it before it bites you.

    --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)