RE: FN-FORUM: Sql Server performance

date posted 25th July 2005 13:20

You may as well set up SQL Server to use 1 processor because unless any
other software will balance between multiple processors you'll not get a
huge benefit from having 2. And yes, bang in some more RAM and it'll
make a huge difference.=20

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of John
Kyle
Sent: Monday, July 25, 2005 1:48 PM
To: Andy Macnaughton-Jones
Subject: FN-FORUM: Sql Server performance


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=20



--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html