[dba-SQLServer] SQL Performance

I have never tested this so be advised that it's nothing more than a
WAG, but you didn't mention the number of processors. The ONLY reason to
run Advanced is multiple processors. I have a tired old dog server with
twin P4-500s and it runs like quick! I have never tried to install
Advanced on a single CPU unit because the docs clearly state that it's
futile. Is it possible for you to back off Advanced and try the
single-CPU version instead?

Another thing to check is how much RAM each process is consuming, or
prepared to consume.

HTH,
Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence (AccessD)
Sent: Saturday, February 21, 2004 3:16 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] SQL Performance


Hi All:

I have just installed a new version of SQL2000 developer on one of my
servers. The sever is not big but has reasonable performance and as I
use it just for testing... It is 1700Mhz, 1GB RAM, Windows2000 advanced
Server software. It is running a number of applications but all seem
happy together; ASP, JSP, Perl PHP, JSP with IIS and MySQL.

The recently installed MSSQL 2000 runs like a dog; so sloooooow. Nothing
else is affected and it seems to run and run to do the simplest of
tasks.

Would anyone have some insight into what could possibly be going wrong.

Any comments would be greatly appreciated.
MTIA
Jim

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com