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 ?

  • For the sake of "management purposes", people will have the SAN guy set up different "drive letters" so they can more easily keep track of their data files, log files, and do some cool things with TempDB.  On a SAN, that's normal "just" all logical junk.  It's a very rare thing where the logical "drive letters" actually match physical drives. 

    So, yes... go ahead and do the separation of different files/uses by drive letter.  Just understand that there's not going to be a performance improvement because you probably won't be talking separate drives just for your drive letters.  And, other systems are also sharing those same disks so the chances of you have 1 or more physical drives dedicated to your drive letters falls somewhere between slim and none and slim just left the building. 😀

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