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
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]
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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.