Am I wrong? If not, how do I prove it short of actually setting up multiple environments for comparison?
Testing aside, if you are running an OLTP update intensive (I/O or bandwidth) environment with lots of random or sequential writes, generally speaking, even with lots of cache, avoid RAID-5 if you can -- regardless of the drive type -- if performance is absolutely crucial to you. In terms of drive preferences, again from a general standpoint, 15 K Fibre Channel (FC) and SAS drives are preferred followed by 10 K FC and SAS (or U320 SCSI) disk drives. There are some storage systems and external appliances that provide additional caching and I/O acceleration capability to mask the performance impact of RAID-5 and slower SATA disk drives.
Again, generally speaking, RAID-1 or 0+1 or 1+0 are also preferred over RAID-5 to avoid parity overhead. If your application or specific tables and objects are heavy I/O bound, then look at solid state disk (SSD), however exercise caution to make sure that you are using SDRAM and not NAND flash RAM for I/O intensive data. NAND flash is less expensive and found in hybrid disk drives or USB thumb drives. However, it is also slower than the more expensive SDRAM commonly used as cache or memory for servers.
Related Q&A from Greg Schulz
Service provider outages should be a warning to customers that keeping data safe in the cloud is a shared responsibility.continue reading
When cloud durability is added to the mix, cloud providers are able to tout a high number of nines of availability.continue reading
Cloud storage can be less expensive from a cost-per-gigabyte perspective, but it's important not to lose sight of other benefits as a value ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.