Best config for 8 HDD

  • Hi,

    I have a brand new shiny HP DL380 Server and have 8 x 146GB 15K SAS drives to play with.

    What would the best way to configure these for redundancy and performance. I will be hosting the database for our MS Dynamics AX server.

    Please advise, any help greatly appreciated

    Zuma

  • zuma01 (4/21/2010)


    Hi,

    I have a brand new shiny HP DL380 Server and have 8 x 146GB 15K SAS drives to play with.

    What would the best way to configure these for redundancy and performance. I will be hosting the database for our MS Dynamics AX server.

    Please advise, any help greatly appreciated

    Zuma

    It's going to be vey dependant on your load, but probably something like

    but consider

    RAID 1+0 for Data (4 disks)

    RAID 1 for Logs (2 disks)

    RAID 1 for Backup (2 disks)

    Unfortunately, 8 disks is really not that many so you don't have many options.

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

  • I've always done:

    2 RAID 1 for OS

    4 RAID 5 for MDFs

    2 RAID 1 of LDFs

    But I think it depends on what you are using the DBs for, I used SQLIOsim to simulate read and writes on my test servers. I'm interested to see what other's have done.

  • How many IO channels do you have?

    What kind of database are you expecting to run (OLTP/OLAP/hybrid)?

    How many transactions per second?

    How critical is your data ... how many seconds/minutes/hours can you afford to lose if you need to go to backups?

    How critical is your uptime?

    └> bt



    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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