SQL 2000 to SQL 2005 migration - vey slow

anoop
anoop 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

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


    blog: https://dynamicsuser.net/nav/b/ara3n
  • DenSter
    DenSter Member Posts: 8,307
    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.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • anoop
    anoop Member Posts: 12
    I have not updated statistics and reindex the indexes.
    Please suggest how to update statices and reindexes.
  • anoop
    anoop 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??
  • garak
    garak 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!
  • garak
    garak 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!

Categories