[dba-SQLServer] SQL Performance

Just a shot in the dark.  Disable all server protocols.  Restart sql server 
service.  Turn on profiler and monitor any thing that goes on.

HTH

Billy

>From: "Jim Lawrence (AccessD)" <accessd at shaw.ca>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] SQL Performance
>Date: Tue, 24 Feb 2004 17:54:20 -0800
>
>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
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=dept/bcomm&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca