SQL 2000 Sp4 - SQL Server Forums

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)

SQL 2000 Sp4

Author

Topic

joolzhaines
Starting Member

2 Posts

Posted - 2007-12-13 : 11:38:35

Hi,

I have a .NET web applcation that runs on IIS 5.0 and windows 2000 server and uses SQL server 2000 SP3 as the back end. When I update to SQL sp4 the web application runs very slow rather then seconds it takes minuits to do SQL statments.

What in SP4 can be causing this as I have tried everything I can

Thanks for your help

Julian

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-13 : 23:32:20

Apply post sp4 fix and rebuild indexes/update statistics.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-12-13 : 23:51:30

also, make sure joins occur between columns of the same datatype.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources