Can anyone give me come feedback as to the benefits of upgrading a raid controller for a db server? I have a Dell R510 with a PERC H700i 512 mb cache for a raid 10. Looking to go to a PERC H700A with 1 gb cache. Will this be worth the upgrade? This machine has a lot of i/o action unfortunately. Also the hyperthreading does not like some of the older sp code with am in the process of cleaning up. It runs Win 2008 with SS2008 R2.
The web server is a Dell R410 and moving from 2 1 TB SATA drives on raid 1 to 4 x 15 k 300 gb SAS drives on a raid 5. I understand I will loose some space. It runs vmware standard with 3 vms two win2008 web servers and one linux web server. This server has always been slower that I expected but the vm setup appears to be very solid.