Post reply

JOB performance on SQL server 2005

  • February 25, 2008 at 1:54 am

    #378864

    We have upgraded our SQL SERVER 2000 to SQL SERVER 2005.

    i couldnt find ,reason of being slower, what can you advice me to check

    did we do someting wrong at set up? When we were upgrading our sql server, we just updated sql server 2000 by

    selecting it at set up, and after set up we set compability level to sql 90.

    Do we need to do smthing else, because we update from sql server 2000?

    Our jobs execution time are extremely increased. Job which took 6 min to finish now takes 2 hrs.

    Please suggest solution

  • February 25, 2008 at 6:46 am

    #781524

    You need to update the statistics on all of your tables. SQL 2005 keeps more detailed column statistics than SQL 2000 did. The 2005 optimiser can use the older stats, but not as efficiently.

    You can do this by rebuilding all of your indexex (not defragmenting) or by running the updaet statistics command for each table.

    UPDATE STATISTICS <Table Name>

    Hope this helps.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

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