SIMS server - SQL 2008, SSDs, recommendations
Just looking for some concensus of opinion on what to do with my current SIMS server. We have an HP DL140 G3, so spec is:
E5335 quad core processor
8GB RAM (4 in use)
2 x 146GB SATA HDD
Server 2003, SQL Server Express 2008.
Obviously, we're not getting the best from this machine at the moment, and some opinions on which way to go with it would be good. Do you think these upgrades would make a decent difference? SIMS in classrooms is okay, but it's heavily used here and seems a bit sluggish now.
Upgrade to Server 2008 R2, utilize all 8GB of RAM.
Upgrade to SQL Server Standard on our EES licence.
Upgrade HDDs to OCZ Vertex 2 (will need to fit a SATA 2 card as onboard is SATA 1)
This was never a top model server, and is a few years old now. However, it's been reliable and done the job for over 3 years. Is it worth the spend? I can't afford a new server, but I could virtualise it onto my VM host instead (quad Opteron, SAS 15k RAID5, 5 VMs already).
Sorry for all the questions, but I'm stuck on the best course of action with this.