[dba-SQLServer] SQL Performance

Jim Lawrence (AccessD) accessd at shaw.ca
Sun Feb 22 19:10:52 CST 2004


Hi Arthur:

Thanks for your suggestion but the advanced model is what I purchased and I
am loathe to change now. The other thing is that every other application
that runs off this server is performing perfectly. Even MS SQL 2000 is,
minus the performance, or lack of it. The RAM is not even being impacted so
my thought that it might be a code segment is bleeding all over, is
unfounded. You might be on to something, with SQL and W2000AdvSer...but
where can I look. There is probably a simple setting somewhere in the
registry.

As all my new apps come from MS Action pack, I have passed my problem on MS
and hope they have something.

Thanks again
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Sunday, February 22, 2004 7:34 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [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



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




More information about the dba-SQLServer mailing list