Re: SQL slowness - cant find my original thread... added info
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/31/04
- Next message: Stephen P.: "Cannot access Sql Db (Northwind) from Server Explorer in VB.NET"
- Previous message: Rob: "SQL slowness - cant find my original thread... added info"
- In reply to: Rob: "SQL slowness - cant find my original thread... added info"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 31 Dec 2004 18:00:05 -0500
You have several different posts in multiple newsgroups. If you add each ng
that you wish this to appear in to the "Newsgroups:" selection box it will
appear in all of them. Then any replies are seen in all others at the same
time. You have many good suggestions in eachof them so I suggest you spend
some time to track them down. Here is my 2 cents.
The two servers are likely not exact in hardware, especially drives. That
can play a large factor in performance. It can also mean one of the novell
clients is working properly and one not. But I would ensure you have run
sp_updatestats on the slow server and see how that works after a while. The
reason the batch requests are lower is simply due to the fact the machine
can't process them as fast as the other one. Have you looked at the query
plans for the same query on each machine to see what is different?
-- Andrew J. Kelly SQL MVP "Rob" <yung.robert@northropgrumman.ca> wrote in message news:c65575c8.0412311320.c002980@posting.google.com... > Hi, > > I have a very strange problem. I have one sql 7.0 box, and one sql > 2000 sp3 box. An ASP app that we've been running off of the 7.0 is > now running about 10x slower on the 2000 box. The 2000 has more ram, > faster processor, and both are running on WinNTsp6a. I have checked > all the possible settings between the two servers, and dont see any > differences that could cause this. The code and tables are exactly > the same on both databases, and I have no idea where to look now. I > must also mention that both sql servers also have a novell client on > it to attach to our netware backbone. I have read alot of articles > blaming the client for slow connections, but the sql 7.0 server doesnt > seem to exhibit any problems. When I put my database on a pure 2000 > server on yet another box, I also have no problems. So my question > is, is there any reason for a 2000 sql server to run slower than a sql > 7.0 one? How can i go about troubleshooting this? Even if I bypass > my .asp app and just do a query in query analyzer, the 2000 box takes > about 10 seconds more to return the same # of rows. I am at a loss... > please help!! > > Have just run some performance monitors on both servers, dont know > what to make of it: > > SQL7 SQL2000 > Query time ~3sec ~13sec > CPU Usage(during query) 15 60 > Batch req/sec 100 60 > > Why wouldnt the batch req/sec be 100 on the 2000 box? Are there any > other monitors I should look into? > > Thanks alot!!
- Next message: Stephen P.: "Cannot access Sql Db (Northwind) from Server Explorer in VB.NET"
- Previous message: Rob: "SQL slowness - cant find my original thread... added info"
- In reply to: Rob: "SQL slowness - cant find my original thread... added info"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
