Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Very slow performance after applying SQL SP4.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-13 : 08:53:04
Jasjeet Singh writes "Strange situation:

Server1: has SP3 and everything is running fine. I have a third party application
that access this server and everything is moving fast.

Server2: Much better Server. Top of the line. Has SP4 installed.
I moved a few database for the third party application thinking that since its a faster server maybe they will have better response. But no luck !
Its so slow that reps have to wait sometimes 30 sec or more to move one line to other when entering order. Its just not working out.

I have another application GPS ( Great plain dynamics) thats on the same server
that works juts fine.

Has anyone expereniced any slowdowns after installing Sp4. What have you doe to fix it. I know I can go back to sp3 but just curious to know what have other people done and if they have any suggestions.

Thanks,
Jazzman."

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-13 : 09:10:05
there are several topics here regarding slowness due to SP4.

Start here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58294




-ec
Go to Top of Page
   

- Advertisement -