SQL server 2008 and server spec

[wijcc]

I have a HP proliant ML570 G2 server with dual XEON 3 GHz server and 4 GB of RAM. I have SQL server 2008 running on the machine but when you run certain searches on SQL server the CPU ultilisation maxes out (100% CPU usage). The current server is running win server 2003 32-bit edition.. so I can not increase the RAM, without having to install a 64-bit OS. The ML570 is also used as a DC.

So I am thinking of getting another (cheap-ish) server just to run SQL server. What would be better for running SQL server more RAM or a more powerful CPU?

Thanks in advance guys

 

[wijcc]

Thanks Stelly..

The DB is one is with GoldMine software, so the DB is maintained and optimised by the tech people from Access/GoldMine, the DB is approx 500 MB in size. So with this size DB what would be a good size amount of RAM?

 

[wijcc]

thanks for the link