Need a database cruncher for a grand

Nippletweaker · 24 Mar 2011 at 11:40

I have a £1000 pound budget to build a machine for running Access and SQL server databases and crunching large amounts of data. I am after any hints or tips on what to look for when specifying my hardware. Obviously fast hard drives and loads of memory but which processor is going togive me most bang for my buck.

All help greatfully recieved

Andrew

Nippletweaker · 24 Mar 2011 at 13:04

Access databases are regularly hitting the 2gb limit and I have to archive off or split out big tables. This is why I'm moving to SQL server. The SQL databases could easily hit 30GB although by then I'll probably have invested in a grown up server.

I was thinking small SSD as main drive and databases on striped raptors? all on SATA 3 should be fairly nippy?

Nippletweaker · 24 Mar 2011 at 13:23

I am nervous about heavily overclocking the system as the data is fairly key. I am sure a mild overclock would be OK....

Nippletweaker · 24 Mar 2011 at 13:39

why not Raptors?

Nippletweaker · 24 Mar 2011 at 14:21

pcAnywhere said:
SSDs are faster, quieter, use less power and have fewer (no) moving parts.

Do they not wear out with repeated writes?