Post reply

Raid for a data warehouse

  • February 7, 2012 at 8:00 am

    #256368

    Hi,

    I am currently in the process of building the requirements for a new SQL server (hopefully 2012) for our data warehouse. To optimize our disks IO I am thinking about this disks configurations:

    OS and SQL binaries RAID 0

    Data files on RAID 1 or 10

    Tempdb on RAID 0 (maybe SSD)

    IDX on RAID 1 or 10

    Log file on Raid 1 or 10

    SSAS databases/cubes on SSD

    Thoughts, recommendations, suggestions?

    Thanks,

  • February 7, 2012 at 9:09 am

    #1443883

    I meant OS and SQL binaries RAID 1

  • February 7, 2012 at 9:17 am

    #1443895

    This has been a subject of great debate and opinions, but I would suggest RAID 5 or RAID 50 for the data files in order to best obtain read performance.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • February 7, 2012 at 2:16 pm

    #1444131

    You'd really have to test performance, but I certainly wouldn't use RAID0 anywhere in my infrastructure. Can you really afford for your data warehouse to be offline because a single drive failed?


    Shamless self promotion - read my blog http://sirsql.net

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

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