The MS SQL server data volume

Posted on 2012-09-12
Last Modified: 2012-09-18
Dear all,

Any suggestion on the RAID level MS SQL server master, msdb, model, tempdB, user database should use ?

Sequencial data pattern should use RAID 10 ?

Question by:marrowyung
    LVL 16

    Assisted Solution

    LVL 1

    Author Comment

    it seem it never suggest the SQL server to use RAID 5 or 6, but only RAID 1+0, how come ?
    LVL 68

    Expert Comment

    RAID1 or RAID10 for tempdb (or even RAID0 if you feel you can risk it).

    RAID10 for log files for databases.

    RAID5 or RAID10 for data files for databases.
    LVL 1

    Author Comment

    for master dB, msdb and model, RAID 1 or RAID 10 as they don't change frequently.

    RAID 10 for log and tempdB.

    for statices data tha't don't have any change, like reporting data, RAID 5.

    For dynamic data that change everyday, every minutes, RAID 10 also, right?\
    LVL 68

    Accepted Solution

    msdb typically changes quite frequently, as job statuses are updated.

    I don't see any reason to distinguish master and msdb from other dbs.

    model will indeed likely change extremely rarely.

    tempdb is, of course, a special case because of the extremely large activity on it.

    yes, raid5 is typically better for data that is read much more often.  then again, almost all db data is read much more often than it is inserted/updated.
    LVL 1

    Author Comment

    "then again, almost all db data is read much more often than it is inserted/updated. "

    how can you know ? analysis data always invole a lot of read and insert and delete.
    LVL 1

    Author Closing Comment

    Thanks you all.

    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.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    745 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

    18 Experts available now in Live!

    Get 1:1 Help Now