Our current SQL Server Machine (which is about 6 years old):
Box: Dell 2900 CPU: Xeon 5160 Dual Core RAM: 4GB HDD: 6x 15k RPM SAS drives in raid 10
Since it's 6 years old, the drives have been spinning for 6 years straight which is making my employer nervous about the life of the drives. We are considering buying, or upgrading our current server. Does my employer have a rational fear, or should the drives last another few years? (they aren't really easy to find anymore, but we do have a hot spare drive inside the computer on standby, and a hot spare server with the same drives in it)
The idea is to either get another 6 SAS drives to run in RAID 10 or to consider getting two SSD (SLC) drives in raid 1. Aside from cost, is there any reason to opt one way or another?
Is it worth upgrading the server in order to get a new CPU and RAM? Our SQL server's CPU generally doesn't peak over 10%. It runs a medium traffic website and internal business apps, but nothing crazy in terms of usage.