mibuso.com
Home› NAV/Navision Classic Client

Strange performance

DuhastDuhast Member Posts: 42
edited 2006-07-28 in NAV/Navision Classic Client
We have a very good performance, but suddenly we experience a poor performance.

I think it could be a report, or a user working with filters.

How can I know what user is causing this poor performance? And what's he/she doing?

Thank you!

Comments

  • DuhastDuhast Member Posts: 42
    We have a 3.70

    It' must be at 3.70 section

    Sorry
  • krikikriki Member, Moderator Posts: 9,118
    [Topic moved from Navision Financials forum to Navision forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • krikikriki Member, Moderator Posts: 9,118
    If you have a Navision-DB, make a form on virtual table "Sessions" and check the field "Sum Intervals". If one value is very big in confront to others, you have the user who causes the problem.
    Ask him which forms, reports... he uses and which filters he uses.
    This way you know if the users uses filters with a bad index that give problems or if the programs have bad indexes.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Alex_ChowAlex_Chow Member Posts: 5,063
    Duhast wrote:
    We have a 3.70

    It' must be at 3.70 section

    Sorry

    Did you upgrade to 3.7 from an older version?

    If so, my bet is that some of the keys used are not the best sort.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Sign In or Register to comment.