On what should i not be pennywise buying a machine for SqlServer 2008?

Posted by Michel on Server Fault See other posts from Server Fault or by Michel
Published on 2010-04-10T20:18:56Z Indexed on 2010/04/10 20:23 UTC
Read the original article Hit count: 334

Hi,

i'm going to do a project for a client and i'll be hosting the database server myself. Normally it would be on my dev machine, but there will also be data pushed into it during developing and testing, so i would like to setup a dedicated test sql server. But, as you might guess, i can't afford to go to Dell and buy one mega 16 core 16 GIG 10 TB raid 5 machine (wow, that sounds cool)

So i have to save the money somewhere... the hardware only has to live for a year (longer is nice of course), and the sql server won't be hit too hard: i guess the average server will only see it as a cough once in a while.

But i do want the machine to be a bit performant: if it does get some data, it must be a bit responsive.

So my question is were can i leave out the expensive parts: is 2 GB enough, or must i take 4GB, is an average processor enough or should it be a top of the bill?

Is Sql server a large resource user or is a simple desktop pc good enough?

It wil run on win2008 by the way.

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about hardware-selection