Post reply

SQL Server 2000 SP4 slows DTS job down

  • September 20, 2007 at 4:12 am

    #92734

    Hi chaps,

    we have just applied Sql Service pack 4 onto out live database.

    We have a DTS which normally takes about 4 hours, it now takes about 10 hours to complete.

    We have looked at the AWE hotfix.

    There are no other processes running and the sever is a high end Dell box.

    Any ideas?

    Cheers

    Bal

  • September 21, 2007 at 4:57 am

    #735172

    there is a cumulative hotfix 2187 after SP4, have you applied that. not sure of all the bugs it fixes but worth a check

    http://support.microsoft.com/kb/916287/

    ---------------------------------------------------------------------

  • September 21, 2007 at 7:40 am

    #735235

    Well, in SP4, it also fixed a bug that was not supposed to be in earlier versions, but was.  This is a snippet.  We had an application who did not test this out completely, and they had all sort of issues.  I can imagine that this could affect jobs, DTS, etc, as it will affect whether indices are used.

    After you install SQL Server 2000 Service Pack 4 (SP4), SQL Server may not choose an index seek if you compare numeric columns or numeric constants that are of different precision or scale. Queries of this kind may run significantly slower in SQL Server 2000 SP4 than in SQL Server 2000 SP3. We recommend that you modify queries or schema so that the data type, the precision, and the scale are the same when comparisons are performed. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

    271566 (http://support.microsoft.com/kb/271566/) SQL Server comparisons between columns and constants with different data types

  • September 21, 2007 at 8:36 am

    #735264

    Yep, spotted that one too.

     

    Cheers

Viewing 4 posts - 1 through 3 (of 3 total)

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