degrated database performance after migration from 370 to 50

Myriam

Hello,
I have made a database migration from the version 3.70 of navision to version 5.00 using the upgrade toolkit
The problem encountered is that the new database presents a big slowness in all the treatments
I optimized it several times, but the problem already persists
Even in sql server level, I tried to defragmentate the most voluminous tables, but no amelioration, the response time is still big especially in runing reports or batch jobs
the database size now is 60GB

Myriam

ara3n

Hello, you need to do an exe upgrade to sp1. 5.0 has a bug for reports on sql that run slow.
I ran into this last week at the client. There is KB article on this with a hotfix. It's much easier to use the s1 executable.