SQL Server Performance

SAS or SCSI and RAID (S.A.M.E)

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by anxcomp, Mar 21, 2009.

  1. anxcomp New Member


    I make preparations for installation new sql server (two node cluster).
    I'm wondering about type of disks (SAS or SCSI) and raid configuration
    (separate RAID or one common RAID)

    I have choice between


    12 * 300GB SAS 15K


    12 * 300GB SCSI U320 15K


    1st option

    4 HDD RAID 10 - disk E: mdf
    4 HDD RAID 10 - disk F: ldf

    4 HDD RAID 10 - disk G: mdf and ldf

    2nd option

    12 HDD RAID 10 (S.A.M.E. Stripe and Mirror Everything)
    and portioning it at three disks (E, F, G)

    Could you help me select best solution, which type of disk and RAID?

    Thanks in advance.

  2. techbabu303 New Member

    On SAS or SCSI check the link below
    Second option is good since it has strip and mirror, but having mdf and ldf in separate drives has its benefits.
  3. satya Moderator

    Cool, I believe this has to be studied further to setup and configure the hardware before you adopt the SQL on new platform.
  4. satya Moderator

    Welcome to the forums.
    I would like to ask about your application & database growth for next 2 to 3 years, also what kind of activites are performed. Is it a heavy transactional database (OLTP_) or a system to store the data for data warehousing purpose?
  5. anxcomp New Member


    My databases takes about 100GB, for next year I expect about 50% growth.I have 10 databases, 3 heavy write/read db and 7 generally for read only, all are OLTP dbs.

    I read some article about recommendation for OLTP systems (generally recommended is separate RAID 10 one for user mdf, second for user ldf, third for tempdb mdf, ldf) but I'm interesting in particular RAID10 vs S.A.M.E technology.

    I don't know any DBA from my friends who would use S.A.M.E with SQL Server.


Share This Page