SQL Server Performance

RAID Configuration

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by tschmitt, Jun 19, 2006.

  1. tschmitt New Member

    In the past I've always been given my SQL servers pre-built with one RAID 5 array. Moving forward I've decided to implement my arrays as indicated in this his Q&A answer: http://www.sql-server-performance.com/q&a38.asp (RAID 1 OS, RAID 5 or 10 data, RAID 1 logs).

    My questions are:
    1) When installing the "SQL Server binaries" on the RAID 1 array does that include the system databases?
    2) Or do you locate the system databases on the RAID5/10 data array?
    3) If the latter, how is that accomplished (i.e., during installation or manually after)?

    Thanks!
  2. tschmitt New Member

    Not sure if the answer(s) are the same for 2000 vs. 2005, but in this specific case I am referring to 2005 (sorry if I posted this is the wrong forum). Thanks.
  3. satya Moderator

    1) By default SQL system databases will be installed in Data directories where the binaries directory is specified.
    2) In specific keep TEMPDB on a seperate drive and leave other 3 on the binaries directory.
    3) TO change TEMPDB location use:
    ALTER DATABASE tempdb
    MODIFY FILE(NAME='tempdev', FILENAME='F:DataFiles empdb.mdf')

    ALTER DATABASE tempdb
    MODIFY FILE(NAME='tempdev', FILENAME='G:LogFiles emplog.ldf')

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
  4. tschmitt New Member

    Satya,

    Thank you for your quick reply. I do not have the monies to implement separate arrays for the tempdb data and log files. Are you suggesting, it will still be a performance benefit if I locate them on the "data" array where all MDFs live and the "log" array where all LDFs live? Thanks.

    Terry
  5. satya Moderator

  6. tschmitt New Member

    Thanks for the links. While they are informative, I couldn't find where they help make my decision since they seem to all suggest a separate array for the tempdb, which I will not have. In my scenario:
    C: RAID 1 for OS, SQL Binaries, swap file
    D: RAID 5 for data files
    E: RAID 1 for logs

    Is it better to leave TEMPDB on C: or move the data file to D: and its log to E: (I think that is what Satya was suggesting in his first reply)? Thanks.

    Terry

Share This Page