Home Forums SQL Server 2008 SQL Server 2008 - General Placing data file , log file and temp file in 1 drive or separate drive ? RE: Placing data file , log file and temp file in 1 drive or separate drive ?

  • November 11, 2018 at 5:21 pm

    #2013161

    Everyone says that they're supposed to be on "separate drives".  If these things are on a SAN, you'll have a bunch of "logical drives" and there's absolutely no guarantee that the files will actually be on separate physical drives unless the SAN guy sets it up that way.  And I can tell you for sure that the SAN guy isn't going to dedicate a 650 GB drive to your paltry TempDB or other small drive requirement.

    Also, if the head-end of the SAN goes south for the winter, all the drives are dead so it wouldn't matter if they were on real live separate "spindles" or not.

    Backups are whole 'nuther story.  If you're storing backups on the same SAN as the actual data, you're making a HUGE mistake!

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