We have a brand new DELL MD1200 with 12-spindles - These are 15Krpm, 600GB SAS drives
The server this is going to be running on is a fairly busy server, has about 90% read, 10% writes (according to a recent evaluation performed by DELL). Important to note, this is "additional" storage and isn't replacing any existing storage arrays.
This server is a subscriber in a transactional replication setup and is primarily used for reporting (so there's heavy stored-procedure executions). So 10% of the "writes" on this server occur from replicated data being stored, custom data tables being written to, and log files.
Here's our existing set up:
MD1200 array (has 12 spindles) in RAID 10
C - 68GB
D - 136GB
E - 1.3TB
F - 1.3 TB
Obviously I'd like to have the best configuration that would give me:
#1 - as many spindles as possible
#2 - best speed for queries that run against it
I was thinking RAID 10, but someone from our Tech Services department made a comment that since the writes are so little overall, that we might benefit from the extra space and performance of a RAID 5 - giwever, depending on which article you read online, some says DO NOT USE RAID 5, some say the performance gain over either choice is negligible.
My initial thoughts were again a RAID 10, using all available disks to add a new drive - G:\ or would it be smarter to split the array up?
Any advice from the experts?
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)