I have a 2003 x32 all patched, recently one of our database were upgraded and the new one required a lot more I/O than prev version. Currently its on a RAID10, all ok before but with new db it is causing the server to lag and even freeze on clients, I am wondering if I can just run 2 SSD on RAID1 as they are around 500+ read and 400+write, I am guessing I may just use this setup for a few months until I can prep another server with may be 2x15k for OS and 6x10k on RAID6 for data.
I know consumer SSD are not set for servers, but should give enough life for a few months even though it will be running a almost non-stop database with very high I/O.
What would you guys suggest ? Thanks