[dba-SQLServer] SQL Performance

Hi Arthur:

At one time, about couple years ago, when I first installed SQL2000, it ran
on the computer as it was suppose to...very fast. There has been no other
applications added, as I always try to keep a server fairly clean. At one
point MSSQL started running slower and slower. The product was one given to
me by a tech-salesman from MS and he said there was no time-out on it. When
MSSQL started to slow down, I assumed it was timing out and removed it.

Now, I have installed a brand-new developers edition, of MSSQL 2000 and it
is already running super slow. This has me totally buffed as there has been
no hardware and few software chances in a couple of years.

Every application works correctly, including MSSQL, no errors of any
kind...logs are clean; but....

Any insight would be greatly appreciated.
TIA
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Arthur
Fuller
Sent: Tuesday, February 24, 2004 9:41 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] SQL Performance


Well, since you are loathe to give up Advanced Server, what are the
chances of you dropping in another CPU of equivalent specs? Second, with
only one CPU this is a helluva load to put on a single server. Third,
does Query Analyzer run as slowly as your app? (Do some selects etc.
from QA to see.)

Arthur

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence (AccessD)
Sent: Sunday, February 22, 2004 5:11 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] SQL Performance


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

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