Wednesday, October 22, 2014

SSD (Raid 1) vs SAS (Raid 10) Sql Server Hardware Recommendation?

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.

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...