Post reply

How to set up Raid Level on one physical array.

  • February 3, 2009 at 9:20 am

    #126019

    Hi all,

    This might not be a right palce to ask this question. but it is convenient to login here plus a lot of gurus.

    I have a MSA1500 CS controller and one SCSI array connecting to it. this physical array has 10 disks.

    I need to build a SQL Server 2005 clustering enviroment on this Array.

    Which way is the best for SQL Server Performance, my application is more heavy read.

    1. Quorum/Raid 1/2 disks/logical drive Q

    Log Files/Raid 1/ 2 disks / Logical Drive M

    Data Files/ Raid 5/5 Disk / Logical Drive L

    one disk as global hot spare

    2. build one Raid 5 on 9 disks. then create 3 logical drives for Quorum/log/data

    Thanks

  • February 3, 2009 at 9:24 am

    #937250

    Option 1 is superior - well anyway that's how mine is set up!

    j

  • February 3, 2009 at 2:10 pm

    #937554

    Option 1 is better than option 2.

    However, since you mentioned that you are talking about a read-intensive system, have you considered RAID 1 for the data files?

    RAID 1 has, I believe, the fastest response time to a read request. The downside is of course the fact that you need to basically buy twice as many disks.

    Just a thought.

  • February 3, 2009 at 2:39 pm

    #937582

    thanks for reply.

    But in this link, It said, one array, one logical drives has high performance. I am so confused.

    http://h20000.www2.hp.com/bizsupport/TechSupport/document.jsp?lang=en&cc=us&taskId=110&prodSeriesId=415598&prodTypeId=12169&objectID=c00622089

    An issue has been identified on the MSA1000, MSA1500 and MSA1510i arrays where degraded read performance has been observed when multiple logical drives (LUNs) are configured to a single array group. The degraded read performance occurs during heavy write utilization of a LUN and simultaneous read access of another LUN on the same array group.

  • February 5, 2009 at 4:01 am

    #938699

    Sorry, can't follow the link.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply