Poor performance after applying SP4

Last Post 23 Apr 2008 11:47 PM by Apos1. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Apos1
New Member
New Member

--
22 Apr 2008 10:02 AM
Hi there, yesterday we applied SP4 on our SqlServer 2000 server running Windows 2003 and instantly we
had problem with performance. Queries that used to run for a second or two now runs way past 4 minutes. Does anyone know what we could do to locate this problem? By the way, SP4 was applied due to the fact that BizTalk2006 needed that SP in order to work properly.

BR
/Anders
Apos1
New Member
New Member

--
22 Apr 2008 10:57 AM
Hi gunneyk, no AWE memory used on the server. Do you have any other ideas?

BR
/Anders
Apos1
New Member
New Member

--
23 Apr 2008 11:47 PM
Yes, sp_updatestats has been run, there has been a few blockings but not on that particular db and yes, the execution plans differs from that one presented when we used SP3. Server Spec:

8 CPU
4 GB Memory
SQL Server 2000 Enterprise Edition SP4
Windows 2003 Enterprise Edition SP1
You are not authorized to post a reply.

Acceptable Use Policy