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

    Hello,

    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

    --------------------------------------------------------------------------------
    DISKS:

    12 * 300GB SAS 15K

    OR

    12 * 300GB SCSI U320 15K
    --------------------------------------------------------------------------------

    --------------------------------------------------------------------------------
    RAID:

    1st option

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

    Node2:
    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.


    --
    Regards,
    anxcomp
  2. techbabu303 New Member

    On SAS or SCSI check the link below
    http://www.tomshardware.com/forum/245760-32-versus-scsi
    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

    Hello,

    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.

    --
    Regards,
    anxcomp

Share This Page