SQL 2000 to SQL 2005 migration - vey slow

anoop

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

ara3n

Have you run update statistics, reindex the indexes?

DenSter

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.

anoop

I have not updated statistics and reindex the indexes.
Please suggest how to update statices and reindexes.

anoop

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

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)

garak

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 :?: