Storage for SQL 2012 and Exchange 2013

• me007today

  Newbie

  Points: 7

  More actions

  May 13, 2013 at 3:31 pm

  #293781

  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