After SP4

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alberto Brivio - 24 Jul 2008 10:45 GMT

Dear ALL,

I have a failover cluster based on win 2000 AS machines and SQL 2000 just
upgraded to SP4 a couple of days ago.

Under normal conditions things seems to be good but when many jobs (dts,
stored procedures and so on) are running together much more time is needed
than in SP3 environment.
So is this a behaviour caused by SP4 and if yes are there any changes to be
applied in order to get the right way?
Another question is, can I do a downgrade to SP3 ?

Regards

Alberto Brivio

Reply to this Message

Uri Dimant - 24 Jul 2008 11:31 GMT

Alberto
I do not think that it is an issue. Have you monitoring your server? How
about the memory?
If you have enabled AWE please make sure that you have hotfix
from(http://support.microsoft.com/kb/899761)

> Dear ALL,
>
[quoted text clipped - 11 lines]
>
> Alberto Brivio

Reply to this Message

Russell Fields - 24 Jul 2008 14:32 GMT

Alberto,

Downgrading to SP3 (if you decide to do it) involves reinstalling SQL Server
2000 and reapplying up to the proper SP and hotfix, then restoring the
master, model, and msdb from before the upgrade. I believe that is
documented in the installation procedure, but it is a fair amount of work.

I know of one installation where performance problems were fixed by giving
tempdb several files to work with, instead of just one. In that case, they
made 10 files, based on this KB article:
http://support.microsoft.com/kb/328551/en-us under the subheading "Increase
the number of tempdb data files with equal sizing".

Then there may be problems with indexed views, if you use those. There is a
fix described at http://support.microsoft.com/kb/906117/en-us

FWIW,
RLF

> Dear ALL,
>
[quoted text clipped - 11 lines]
>
> Alberto Brivio

Reply to this Message