Navision 4.0 SP3 is very slow in one company only

mohsinmohsin Member Posts: 2
edited 2011-04-11 in SQL Performance
i am facing problem in 1 of our company data a database consist of 6 companies of navision, 1 company is facing slowness while opening gl total field in chart of accounts, any solution to the prolem.

Comments

  • SavatageSavatage Member Posts: 7,142
    If using sql check the sql performance forum here at mibuso.

    with the limited information provided it's impossible to answer your question.
    we can speculate all day without server or system specs.
  • strykstryk Member Posts: 645
    As Harry suggested, you should search the forum about "SQL Performance" and you'll get gazillion of advices and reccomendations!

    With NAV 4.0 SP3 there's a high chance that basically the SIFT management is causing trouble; check out this one:
    http://dynamicsuser.net/blogs/stryk/archive/2010/05/29/optimizing-sift-and-vsift.aspx

    Of course, there are probably many more things to be discussed, but for this you need to provide more background information about your system.
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • krikikriki Member, Moderator Posts: 9,112
    [Topic moved from 'Navision Financials' forum to 'SQL Performance' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.