SQL 2000 to SQL 2005 migration - vey slow

anoopanoop Member Posts: 12
edited 2008-08-04 in SQL Performance
Hi,

I have restored the SQL backup of NAV database from SQL 2000 into SQL 2005. It has become very slow. Posting is now taking 15 minutes, earlier it was lass than 1 min.........please help 8-[

Comments

  • ara3nara3n Member Posts: 9,255
    Have you run update statistics, reindex the indexes?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSterDenSter Member Posts: 8,304
    That's not enough detail for us to be able to help you out.

    Is your SQL Server 2005 instance running on the same machine as your SQL Server 2000? What is your hardware setup? What version of NAV are you running? There are a LOT more things to look at.
  • anoopanoop Member Posts: 12
    I have not updated statistics and reindex the indexes.
    Please suggest how to update statices and reindexes.
  • anoopanoop Member Posts: 12
    That's not enough detail for us to be able to help you out.

    Is your SQL Server 2005 instance running on the same machine as your SQL Server 2000? What is your hardware setup? What version of NAV are you running? There are a LOT more things to look at.

    I have uninstalled the SQL 2000. The hardware is same for both.

    Does SQL 32 bit or 64 bit makes any difference??
  • garakgarak Member Posts: 3,263
    so, you have no updatestats and no rebuildindex. do you have create this maint. jobs under 2000 :?:

    How to create a job for rebuildindex or updatestats :?: Search the forum, read online help or, better read the manual on product cd (w1w1isql.pdf)
    Do you make it right, it works too!
  • garakgarak Member Posts: 3,263
    i think you are not the DBA. so ask you db admin if he has created these jobs.

    Also: Which Version of Nav do you use and which Version of SQL2005 you are use. Do you have enabled some traceflags or some indexhints :?:
    Do you make it right, it works too!
Sign In or Register to comment.