FN-FORUM: Sql Server performance

date posted 25th July 2005 13:14

I have just had a look at the hardware spec of a clients sql server 2000,
windows 2000 server setup and I have noticed it has the following:

2x 2.0Ghz pentium xeon chips
256Mb RAM

Now as far as I can see this is basically rubbish and incapable of running a
web server and db server on the same machine, I should imagine all of the
performance issues will be due to the fact that it will be using the hard
drive as virutal memory almost constantly and be dead slow. I have
recommended, as RAM is cheap, to up it to 2Gb of RAM and this should help it
out and I had also thought of specifically setting up sql server to use one
processor or is this a bad idea?

Help appreciated

John