Upgrade 2005

  • We just attached a 2000 db to a 2005 db and are having issues with performance.

    EVERYTHING is taking longer and the cpu is at 100%.

    We ran dbcc updateusage and checkdb but nothing came out of those results.

     

    Any help would be greatly appreciated.

     

    Thanks

    Susan

     

  • We are using the The 64-bit Intel Itanium.

    Any help would be greatly appreciated.

    Thanks

    Susan

     

  • Hi Susan,

    You need to update your statistics and also rebuild your indexes in this case.






    Regards,
    Sudheer 

    My Blog

  • right, thatwas the first thing we did, but saw no difference in performance..

    Anything else I could do? or look at?

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

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