Strange performance

Duhast
Duhast 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

  • Duhast
    Duhast Member Posts: 42
    We have a 3.70

    It' must be at 3.70 section

    Sorry
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

  • kriki
    kriki Member, Moderator Posts: 9,121
    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_Chow
    Alex_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

Categories