Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

NAV Application service slowdown

Posted on by Microsoft Employee

For the last few months we've had periodic issues with our NAV 2015 install where some users will experience a "spinning wheel" or "white screen" as the service appears to be slowing down.  Sometimes it's all users and sometimes it's just some users.   New users logging in will be unable to proceed due to the spinning cursor.  No one reports a blocking message.

I can fix it by restarting the service or by switching users to a new NAV service.   In the latter case users can log in without a problem and proceed normally even while the old service is still flakey.   All indications is a service problem and not a SQL issue.  Sometimes we go weeks without and issue; now we've had two in as many days.

The application server and SQL server are fine and not over utilizing any resources.  Also after the incident there are no events in the respective server event logs that are unusual or could point to a problem.

Any ideas?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    Thanks for the reply.   We looked into network congestion but traffic is fine.  Also switching services on the same server clears up the problem.   Puzzling.   When it happens we only have a minute or two to look for issues as the phone starts ringing to get people back online.   We plan for one test each outage.   It delays a minute but we get some data.

  • Judith Hirst Profile Picture
    Judith Hirst 51 on at
    RE: NAV Application service slowdown

    Hi Michael,

    We have been experiencing a similar issue over the past several months.  We concluded that it was not NAV 2015 because if we are directly on the server, the issue does not happen.  After some investigation by a specialist in network setup, we discovered that we had some bad switches and cabling issues.  The two problems caused time outs or extremely slow responses.  We are now having the cabling redone, and new switches are going in.  While your problem may be quite different, this solution worked for us.

    Cheers, Judith

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    Thank you.   We have NAV2015 so I will try it on our development system and see how it works.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: NAV Application service slowdown

    Michael,

    Try the Application Profiler

    www.navisionworld.com/.../application-profilercode-coverage-in.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    In our previous version of Navision (an old one) I had a form from the Session table that monitored reads and writes by users.   When we encountered issues like this I could quickly run that form and see which person (and it was usually accounting) was using up a lot of disk reads.   I would contact them and asked them what they were doing and it was invariably something like exporting all the G/L entries for last year.   I told them to use my export button at the top (which had built in sleep commands) and all was better.   I wish there was something like that for this version of NAV.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: NAV Application service slowdown

    Michael,

    I have seen simlar kind of issue recently and the reason in my case was one user was running a report or exporting the page contents which has many records to excel by using send to excel function, which hang all the users and they see the spinning wheel for a longer time.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    Memory doesn't seem to be an issue.  I've never seen excessive memory usage during a hang-up and we run scripts each night that optimize our indexes.   My solution to the slowdown is to switch the config file from pointing to NAV80 to NAV80_2 and have affected users log out and back in.   Then when it happens again I switch back from NAV80_2 to NAV80 service on the same server.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    I don't think it's the SQL as if I switch The NAV Application service (on to same server) the users on the new application service are fine but the ones on the old service are still hung.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    It is set to "Always".

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV Application service slowdown

    What is the field value of "Automatic Cost Adjustment" in Inventory Setup?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans