SQL Server Performance

Raid configuration on a dell 2950

Discussion in 'ALL SQL SERVER QUESTIONS' started by Jörgen, Mar 8, 2012.

  1. Jörgen New Member

    Hi

    I am setting up a new installation of sql server 2008 on a dell 2950 with 6 disks.
    The sqlserver is going to be used of 50 users from a business system.
    My question is , what is the best raid configuratuion on this ?
    I was thinking of doing like this.
    2 disk in a raid1 with two partitions for system and logfiles.
    4 disks in a raid 10 with the databases and tempdb.
    Is this a good configurartion or what over options do i have ?
  2. Shehap MVP, MCTS, MCITP SQL Server

    First welcome to forums ,

    Basically, I do recommend :

    1. RAID 10 for log files where it has more Write operations particularly more if you have OLTP system (DML transactions more than select transactions)

    2. RAID 10 for TempDB particularly more if you have intend to apply some solutions/features that make expose overload on TempDB like :

    · Read Committed snapshot isolation level using row versioning

    · Sort in TempDB while index rebuild jobs

    · Using much Temp tables/ table variables/ Cursors in your codes

    · ..etc

    3. RAID 1 for other disks hosting users DBs + master DBs.
  3. Jörgen New Member

    Hi

    Thanks for your answer.

    So you think it's best to have the DB's on the raid1.
    But on the same harddrive i also have the system and pagefile.
    You don't thinkt this could be a problem in performance.
  4. Luis Martin Moderator

    You can change the pagefile to other drive. About system (having tempdb in raid 10) I don't see any performance problem.

Share This Page