Hanging the System while optimizing only Item Ledger Entry

ajaybabuChajaybabuCh Member Posts: 208
edited 2007-04-21 in SQL Performance
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
Ajay

Comments

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    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.
Sign In or Register to comment.