Service Pack 4

Question

Service Pack 4

aureolin

Hall of Fame

Points: 3520
More actions
May 25, 2005 at 1:19 pm

#102552
Earlier this month MS announced Service Pack 4 for SQLServer 2000. You can find information (and the download) on the Microsoft site at here and a list of bug fixes at here
But - the real question is: what are you doing about SP4?
- Are you planning on installing it?
- Waiting to see if anyone else has meltdown because of it?
- Planning on ignoring the whole thing?
This thread is to discuss both your intentions and experiences with SP4. Let us know your experiences with SP4.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

sa24 SSCrazy Eights Points: 8027 More actions · Answer 1

SQL server SP4 has more fixes and does not introduce any new features. With this said, i think you should be safe to go ahead and install SP4 but you definetely need some testing. The reason we haven't installed SP4 yet is that there is a bug if you are using memory more than 2 gb and we are waiting for the fix from microsoft.

Steve Jones - SSC Editor SSC Guru Points: 734449 More actions · Answer 2

I dropped it on my laptop (Personal Edition) with no ill effects. Direct from RTM to SP4 and it worked fine.

Vidas Zabinskas Hall of Fame Points: 3258 More actions · Answer 3

We have installed it on SQL server cluster with win2003 and SQL server enterprise edition, where each server has about 4GB. All look good

RML51 SSCarpal Tunnel Points: 4410 More actions · Answer 4

We can't use it on most of our production servers because of the problem with AWE.

We usually don't rush to install SPs.

sswords SSCrazy Eights Points: 8207 More actions · Answer 5

LOL...waiting for SP4a?

Fortunately (or not) for me my hands are tied. Our vendors have to sign off on it before it can be installed on production machines. And unless there's a critical issue being addressed, they usually take their time with this process.

My hovercraft is full of eels.

Gagandeep Singh SSCommitted Points: 1513 More actions · Answer 6

Don't apply SP4 if you have eanbled AWE.

http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx

http://support.microsoft.com/?kbid=899761

Jane Matheson-154829 SSCertifiable Points: 5522 More actions · Answer 7

Is AWE the only issue with memory issue > 2G? What about 4 G with the /3G switch set?

Gagandeep Singh SSCommitted Points: 1513 More actions · Answer 8

I think the problem occurs with only with AWE enabled, because /3GB switch is for Widows User mode address space enlargement and AWE is specific to SQL Server. But there are other problems associated with SP4 - I still recommend that you should wait for atleast 6 months after the release of a service pack.