Upgrading from SP3a to SP4 and Post SP4

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)

Upgrading from SP3a to SP4 and Post SP4

Author

Topic

dewacorp.alliances

452 Posts

Posted - 2007-11-02 : 01:24:39

Hi all

Due to the Ms is no longer support the 3a unless having an special agreement, we are pushing the environment to SP4 soon.

Is there anything that I should to know to upgrade this part of confirming the vendor application about SP4 and testing it? Is there any file size that suddenly going crazy like from 7 to 2000 before? Or something ?

Any input regarding this I am really appreciated.

Thank you.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-02 : 02:26:08

There are some patches that you should install after SP4.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

dewacorp.alliances

452 Posts

Posted - 2007-11-04 : 17:30:28

quote:

There are some patches that you should install after SP4.

We are going to apply these things as per Ms Support suggestion:

Service Pack 4
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en

Post SP4 Build
http://www.microsoft.com/downloads/details.aspx?familyid=9C9AB140-BDEE-44DF-B7A3-E6849297754A&displaylang=en

Which I think this should cover all SP4 patches.

Thanks

Kristen
Test

22859 Posts

Posted - 2007-11-04 : 17:49:22

"Is there anything that I should to know"

I saw issues discussed where there was severe degradation of performance when JOINing between values of different datatypes - i.e. where an IMplicit conversion was made.

I don't know what the upshot of this was, and whether there is just a Config parameter to adjust for this, but if not you probably should test against it.

See: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Concerns%20about%20SQL%202000%20SP4
and: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66737

Kristen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources