none
Storage for SQL 2012 and Exchange 2013

    Question

  • Hello
    I am planning for a storage using Dell MD3200f with 7x600GB 15K SAS HDD, 4x4TB NL-SAS HDD. This will cater SQL 2012 Std and Exchange 2013 Std for 100 users.

    This is NOT a virtualized environment.

    I would create RAID 1 for OS on 300GB 15K HDD available on the server.
    However, rest of the data resides on the SAN. The expected database transaction is 3000 per minute & IOPS at 500.

    Plan A - Create RAID 10 across 6x600GB 15K, which will contain SQL application, SQL DB, TempDB, Log + Exchange Application. Mailbox will sit on RAID 5 using 4TB HDD. [Pro: HDD space well
    utilized]

    Plan B - Create RAID 10 across 4x600GB 15K, which will contain SQL Application, SQL DB, TempDB + Exchange Application. 2x600GB 15K RAID 1 will be used for log. Mailbox will sit on RAID 5 using 4TB HDD. [Pro: Log is on
    separate HDD, Con: RAID 1 used for log is under utilized]

    Plan C - Create RAID 1 using 600GB 15K for SQL DB, Create RAID 1 using 600GB 15K for TempDB,
    log. RAID 1 using 600GB 15K for SQL Application, Exchange Application. Mailbox will sit on RAID 5 using 4TB HDD. [Con: HDD capacity cannot be well utilized]

    Which of the above would be recommended?

    Thank you in advance
    George
    Thursday, May 16, 2013 6:28 PM

Answers

  • Hello,

    RAID 10 is recommended for both SQL Server databases and Exchange databases.

    I would choose option A, because even with a read% = 25 and write% = 75 (more write operations than read operations) you would obtain an approximate IOPS of 664.94. I used a 15K fibre channel drive as reference for my calculations not a SAS drive, but the result of the calculation should not be very different.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com



    Thursday, May 16, 2013 7:38 PM