Slowdown after upgrade to 2000

Last Post 19 Jul 2004 06:11 AM by albino. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
albino
New Member
New Member

--
29 Jun 2004 10:19 AM
We were running SQL Server 7 on our servers, and had no problems. We recently upgraded to SQL Server 2000, and one page in one web application started taking about 10 seconds to load (it used to be almost instantaneous). I ran SQL Profiler, and got these results:

SELECT TOP 1 * FROM VW_JobList_Nice ------2004-06-29 13:52:50.083------2004-06-29 13:52:50.083
SELECT Client_Name, Id FROM Clients ... -----2004-06-29 13:52:52.100------2004-06-29 13:52:52.100
SELECT * FROM Status_Values ... --------------2004-06-29 13:52:54.130------2004-06-29 13:52:54.130
SELECT * FROM Priority_Labels ... --------------2004-06-29 13:52:56.130-----2004-06-29 13:52:56.130
SELECT * FROM Custom_Field_Properties ... -2004-06-29 13:52:58.147-----2004-06-29 13:52:58.147
SELECT * FROM Custom_Field_Properties ... -2004-06-29 13:53:00.147-----2004-06-29 13:53:00.147

All those tables are pretty simple, except for VW_JobList_Nice, which is a view that INNER JOINs a bunch of tables.

As you can see, none of the queries are taking any time to run, but there is a two-second delay between each one. None of the ASP code changed, the only change was the SQL Server version.

Does anyone know what might cause this?
albino
New Member
New Member

--
30 Jun 2004 01:04 PM
The web server (IIS) and SQL Server are running on the same box.
albino
New Member
New Member

--
01 Jul 2004 03:16 AM
What do you mean?

Note: I am a programmer, not a DBA or hardware engineer. The reason I'm working on this is that it's my software that's running slow. ;-)
albino
New Member
New Member

--
19 Jul 2004 06:11 AM
As it turns out, it was caused not by SQL Server 2000, but by Service Pack 3a. I installed Hotfix MS03-031, and that fixed it.
You are not authorized to post a reply.

Acceptable Use Policy