Hanging the System while optimizing only Item Ledger Entry

ajaybabuCh · 2007-04-21

Hi

We migrated Navision 3.7 native database to SQL Database.

After migrating to SQL Database , While I am trying to optimize only

Item Ledger Entry Table with 2935329 records, it has strucked up. It won't

even move to one percent.

Can anybody have an idea on this

Regards
ajay

Marije_Brummel · 2007-04-21

You can also try to reindex via SQL Server.

Do you know how to do that?

What you should also do is create a maintenance plan to do the backups, reindexing, SIFT cleanup and creating proper statistics.

If you do this correct you can also disable all the autooptions.

Hanging the System while optimizing only Item Ledger Entry

Comments

Categories