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.
Best Answer
From a disaster recovery, performance and power consumption point-of-view, I'd upgrade ASAP. You can't predict hardware failures, so it might be your disks, the PSU, the motherboard or some other component.
I tend to go by a rule of thumb that says to upgrade professional setups at least every 3 years because performance and power effeciency has usually doubled in that time. Might be hard to find spare parts, too. If your PSU or motherboard dies, how quickly can you restore service? Did you test this? Is the timeframe acceptable for the business?
An awful lot has happened in the last 6 years. You'd have to look really hard to find a new Xeon-based systems that's slower than what you already have.
If your entire database can fit in 4GB or 8GB RAM, you'd benefit greatly from a new CPU and a gigabit network interface.
Do you have any sort of monitoring on this system? Are the disks even moving, except for writing data (which can't be a lot if there's only 2GB of data after 6 years) and access logs?
For what it's worth: Modern SSDs can do insane amounts of writes and the myths from 15 years ago no longer apply. SSDs wear just like mechanical drives do, they're just much faster and reading and writing data. Not sure you have enough data in your database to feel much performance difference, though.