run adjust cost item entries are very slow on NAV2009

NW-Dev
NW-Dev Member Posts: 5
edited 2010-06-14 in SQL Performance
Does anyone have a good way to speed up adjust cost item entries process?

I have upgrade from NAV5Sp1 native to SQL NAV2009 and it take 5 times double from the old version.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Use the client monitor (or even better : SQL traces) to see what SQL-statements are sent to the server. Maybe some index or SIFT is missing.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • dvd679
    dvd679 Member Posts: 1
    Did you manage to solve this. I am experiencing same problem with an upgrade from NAV4.03 to NAV 6 SP1.
  • kriki
    kriki Member, Moderator Posts: 9,121
    Best try the method I described earlier to see what is happening on SQL Server.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories