Post reply

SLOW PERFORMANCE AFTER 2000 TO 2005 UPGRADE

  • November 10, 2008 at 9:26 am

    #202600

    We recently upgraded one of our servers to 2005. now we are experiencing slow performance on stored procedures.

    We did a backup an restore for the upgrade, rebuilt the indexes and ran update statisitics.

    but no matter what I do the proc still runs slow

  • November 10, 2008 at 10:09 am

    #896402

    in another thread on a similar issue, where his 2005 server was slower than his 2000 with the same query, someone finally identified that in their case, they had seen that databases that were upgrade form previous versions were still slow/no improvement even after updating statistics.

    everyone was suggesting just updating statistics, but until he dropped statistics and then updated statistics, he did not get the performance fix he was looking for.

    something about an upgraded database from one version to a higher version appears to prevent update statistics from doing it's job.

    make a script to drop statistics on your tables, then update statistics on the same tables.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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