SQL Server 2008 Hard drive considerations

Posted on 2009-12-17
Last Modified: 2012-05-08

I'm going to be setting up a new server soon and I have two choices to consider regarding the hard drive configuration.   For the data files, I need to use a RAID 5 array.  For the operating system and transaction log, I can either set up two separate mirrored volumes (one for OS and one for TL), or a RAID 10 volume for the both of them to occupy.  Suggestions?
Question by:ccwestbrook
    LVL 26

    Expert Comment

    it should be better that you plan different disks for os, data, log and temp
    data disk should be raid 5 or raid 1+0 depending on your need and write performance..
    log and temp disks should be raid 1
    os disks depends on your hardware possible raid 1 or raid 1+0
    LVL 41

    Accepted Solution

    The bottleneck will be the RAID5. Then, from speed point of view, it is not relevant if you use RAID 10 or two mirrors. I would use two mirrors as physically separated storages.

    Author Comment

    What about using multiple RAID 1 volumes instead of RAID 5 or RAID 10 for the data files?
    LVL 26

    Assisted Solution

    In my site I prefer using raid 1+0 for data files..

    Author Closing Comment

    Thanks for the input.  I am going to go with a 6 disk RAID 10 volume for the data files, and two mirrored volumes for TL and OS.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now