none
Which RAID types to be used for a new SQL Server 2008 installation?

    Question

  • I have the following RAID types to choose from 0, 1, 5, and 6.

    I think I should do these:

    • RAID 1 for all system databases (log) and user databases (log)
    • RAID 1 for tempdb (both data and log)
    • RAID 5 for all system databases (data) and user databases (data)

    Thanks for any suggestions.

    BTW, I have not included OS, SQL Server application, page file(s), and backups in this list.   They are probably will be on the local single physical drive.

     

     

     

    Friday, October 07, 2011 11:09 PM

Answers

All replies

  • Hello,

    Use RAID 1 for log files and tempdb. Use RAID 1 for data files. Use separate RAID 1 for the operating system and programs.

    A separate drive for backups may be a good idea.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, October 07, 2011 11:22 PM
  • Hi PCSQL,

    Although RAID is not a part of SQL Server, implementing RAID can directly affect the way SQL Server performs. RAID levels 0, 1, 5 and 10 are typically used with SQL Server.

    Data striping (RAID 0) is the RAID configuration with the best performance, but if one disk fails, all the data on the stripe set becomes inaccessible. RAID level 0 doesn't provide redundancy and doesn't protect against disk failure. A common installation technique for relational database management systems is to configure the database on a RAID 0 drive and then put the transaction log on a mirrored drive (RAID 1). In addition, use RAID 1 for operating system and SQL Server application.

    If data must be quickly recoverable, consider mirroring the transaction log and putting the database on a RAID 5 disk. RAID 5 provides redundancy of all data on the array.

    For more information, you could refer to:
    http://blogs.msdn.com/b/kronos/archive/2010/03/30/understanding-raid-for-sql-server-part-1.aspx

    http://blogs.msdn.com/b/teamcenteronsql/archive/2010/04/01/understanding-raid-for-sql-server-part-2.aspx

    http://msdn.microsoft.com/en-us/library/ms190764(v=SQL.100).aspx

     


    Hope this helps.
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    • Marked as answer by Stephanie Lv Monday, October 17, 2011 9:13 AM
    Monday, October 10, 2011 6:35 AM
  • The best is RAID 10 for data files , you can place probably tempdb as well on that array

    RAID (1) Mirroring for LOG files

     


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, October 10, 2011 8:23 AM