SQL Server Performance

SQL server Disk Config

Discussion in 'SQL Server 2008 General DBA Questions' started by ismailadar, Feb 17, 2011.

  1. ismailadar New Member

    Hi all,
    I have prepared an SQL server machine and Can you advice me about disk configuration? I have 5 disk and how can i confiure it? For examle RAID1 for OS with two disk and RAID 5 for Data and backup with 3 disk?
    Can you give me any advice?
    ismailadar, Feb 17, 2011
    #2

  2. Luis Martin Moderator

    Check:
    http://technet.microsoft.com/en-us/library/cc966534.aspx
    Luis Martin, Feb 17, 2011
    #3

  3. satya Moderator

    What kind of RAID disks attached to that server?
    Can you find out from your storage people to get information, otherwise look at Computer Management on that server and get information.
    satya, Feb 17, 2011
    #4

  4. ismailadar New Member

    There are 5 disk on server and i have decided to congifure it like this:
    Firstly i will add a new disk and i will configure three mirrored volume (RAID 1 ) the first one will hold OS ,the second will hold databases and the last one will hold backups.
    Thanx for your replies
    ismailadar, Feb 17, 2011
    #5

  5. Luis Martin Moderator

    Where are you planing to store system databases?
    Luis Martin, Feb 18, 2011
    #6

Share This Page