Strip size for Window SQL Server

Posted on 2014-08-10
Last Modified: 2014-08-21
Need to configure different RAID group on the Window 2008 R2 SQL Server. What is the recommended strip size for

1. OS (RAID 1)
2. SQL TempDB
3. SQL Log
4. SQL Data

Default setting for RAID is 64K. Will that be too big for OS ? Tks
Question by:AXISHK
    LVL 23

    Assisted Solution

    RAID10 or RAID60 64K  stripe size should be fine, for all of those.
    You definitely don't want large stripes such as 128K  with a typical SQL server workload.
    You're going to want to make sure you format all the above  (except OS)
    with a 64K  allocation size within NTFS as well,  when formatting the disk within Windows to create the NtFS filesystem.

    If in doubt, your storage vendor should generally provide some best practice guides for SQL server.
    For most they could generally be summarized as:

    * No RAID5.
    * Provide plenty of battery-backed cache memory.
    * 4K/default allocation unit size for boot drive, 64K allocation unit size and stripe width for all other volumes.
    LVL 68

    Assisted Solution

    If the OS is on a separate drive set, 4K usually works best for it.

    SQL Server data files generally work best at 64K.

    SQL Server log files can vary much more.  Anything from 16K to 64K could be best, but 64K is certainly acceptable, and would keep things simpler by having the data stripe size match the log stripe size.
    LVL 55

    Accepted Solution

    Bigger than 64K may have a slight detrimental effect since one single disk may be needed to get two 64k extents from so they would have to queue, smaller than 64K can have much worse effect since more than one of your disks will be tied up for each extent you read and you really want them to be reading one each.

    Author Comment

    Do u mean I should just keep 64K strip size for each RAID group, correct ?
    LVL 55

    Expert Comment

    Only meant for SQL data, but what controller is it. "strip size" suggests HP and they generally use a large strip size by default as it's best for most things.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free book by J.Peter Bruzzese, Microsoft MVP

    Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

    Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
    I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
    This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

    759 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

    14 Experts available now in Live!

    Get 1:1 Help Now