I need to upgrade our internal Development Sql Server hardware. Right now it's an Intel Core2 Quad Q6600 @ 2.4Ghz. I feel that the CPU is fine.
It's got 4Gig ram - yuck.
It's got a sub-par HD in it.
So i'm thinking of pumping up the RAM and the HD to a few (eg. OS on Sata, HD's on SSD - not sure about the system tables .. maybe move them on to the SSD and logs on SSD (we don't really care/use the logs for our dev).
Lastly, we backup the DB's over the intranet to another device/server/HD.
So - does anyone have any good recommendations for
- Motherboard
- Case (and a PSU possibly, if case doesn't have one).
- SSD's.
I can get RAM all over the place. I'm guessing I'll want at least 8Gig. Would love to go 12 or 16. I'd want to use the same CPU unless i'm convinced otherwise. Remember, this a DEVELOPMENT SQL Server, with half a dozen users hitting it MAX .. which is never the case, really. Also, something a bit conscience to the enviro would be sweet. Small form-factor a huge win.
Oh, finally -> i don't want to buy some dell Rackserver or prepackaged thing. I love building my pc's, etc. Any ideas folks?
UPDATE
Here's a link by an Aussie SQL SERVER GROUP about using SSD's for Sql Server.