Post reply

Move Job from SQL 2000 to SQL 2008 very Slow

  • June 18, 2009 at 6:05 am

    #207167

    We have a script that ran fin in SQL 2000 - we have moved it to a dfferent server and now it is so slow that it won't complete in 2 days

    The script is mainly creating new tables

    Has anyone else encountered this problem and found a solution??

  • June 18, 2009 at 3:35 pm

    #1012096

    jackiepenn (6/18/2009)

    We have a script that ran fin in SQL 2000 - we have moved it to a dfferent server and now it is so slow that it won't complete in 2 days

    The script is mainly creating new tables

    Has anyone else encountered this problem and found a solution??

    show us the script! 😛 ... also, how's your drive's layout: RAID type, drive partitions, etc ... how much RAM and CPU, etc

  • July 8, 2009 at 8:43 am

    #1021723

    Usually a problem if you haven't updated statistics and updated usage.

    It's a good idea to rebuild all indexes to be sure.

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

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