I am toying with the idea of upgrading our database server, its not really a proper database such as SQL, more of an old database with records stored in individual files, currently its just over a million records.
The server is an Intel Quad 2.4GHz, Server 2003 x 32 with 4GB.
Now its on an Adaptec 2405 running RAID10 with 4 drives.
Performance seem ok, but everytime the software manufacture upgrade their server modules, it will slow down, this can go on for months until they accept liability and fix the software, but in the meantime, blame the hardware for loss of performance.
I am thinking of upgrading the server to a faster Quad or even dual Quad (when upgrade to SBS2011), but with the RAID card (ie. 580x), I plan to use RAID10 still, but would a better card with 512MB cache boost performance by a huge margin ? The drives I have in mind are the RE4 1TB x 4, I thought about using 8 x 15K SAS 300GB on RAID6 to give the protection, performance as well as value for money, but a bit throw back by the rebuild time should one of them playing up.
The server currently running on UPS with 30-40 mins backup time, but I guess a RAID battery backupis a must also.
So my questions is :
1. RAID6 or RAID10x4
2. Would cache make any difference on RAID10 ?
3. Any other bottleneck I should be aware of ?
What would you guys suggest ?