Maxtrix form - loads slow with some users

anon2132
anon2132 Member Posts: 12
edited 2009-01-29 in NAV/Navision Classic Client
Hello,

Got a strange one here...

Same client (401 objects, 403 SQL Exe), license, cleared zup files, and same NAV permissions, same 'net type'.

However one user can open and view figures on the matrix form much quicker than others.

User1 = 1 second
User2 = 30 seconds

These are setup as database users.

Any pointers most welcome....

Comments

  • DaveT
    DaveT Member Posts: 1,039
    Hi,

    Have you tried the client monitor or SQL profiler to see where the bottleneck is?
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • anon2132
    anon2132 Member Posts: 12
    DaveT wrote:
    Hi,

    Have you tried the client monitor or SQL profiler to see where the bottleneck is?


    I'm not really sure on how to do this, but if that is the next step, I'll find someone who can :)

    Thanks
  • kapamarou
    kapamarou Member Posts: 1,152
    Just to make sure, when you say cleared ZUP file you mean that everything is the same.

    So cache is the same in both users and also they haven't changed the view of the form (meaning that the smaller the cell in the matrix the more cells appear, the more calculations are performed)...
  • anon2132
    anon2132 Member Posts: 12
    kapamarou wrote:
    Just to make sure, when you say cleared ZUP file you mean that everything is the same.

    So cache is the same in both users and also they haven't changed the view of the form (meaning that the smaller the cell in the matrix the more cells appear, the more calculations are performed)...

    Yes exactly...
  • DaveT
    DaveT Member Posts: 1,039
    Hi

    The client monitor is staightforward to use Tools -> Client Monitor and press start. Run the matrix form and then stop the client monitor and compare the two output to see where the delay is.
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html
  • kine
    kine Member Posts: 12,562
    But if you are not partner, you need additional granule in your license to be able to run the Client Monitor. But because you are using MS SQL, you can use the SQL profiler for looking for more details...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • garak
    garak Member Posts: 3,263
    Check also with the SQL Profiler.
    It's under Start -> Programs -> SQL 20005 -> Perfomance -> SQL Profiler.

    In the SQL profiler you activate following Events

    Showplan XML (to see which index is used and if he scan or seek)

    Stored Procedures
    - PRC:Completed
    - SP:Completed
    - SP:StmtCompleted

    TSQL
    - SQL:BatchCompleted
    - SQL:BatchStarting

    Filter:
    Session -> the Sessionid of the user to see only the activity of the user or
    Reads -> over 5000 //view all Reads over 5000 pr
    Duration -> 2000 ms //view all processes over 2seconds

    Do you use indexhint or recompile?

    Regards
    Do you make it right, it works too!

Categories