Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Nav 2013 performance issues

Posted on by Microsoft Employee

Hi,

 

We have been experiencing a speed issue with our NAV 2013 (not R2) system, when opening a customer card or item card there is generally a delay of between 2-10 seconds before the page displays the information, so the page open right away but blank then NAV thinks about displaying the information 2-10 seconds before display the data.

 

Our dynamics NAV support company have looking at the issue for over a years now and have thrown in the towel and said we can see there is an issue but we don’t know what causing it and we have run out of idea’s.

 

When the issue first appear or at least when it got to the stage where we said “this is a problem now”, we were on a two tier setup so on the service tier (single service tier for up to 75 concurrent users) was on the same server as the SQL database, once we raise the issue the support company moved the service tier onto another server and setup two service tiers, but the issue remained.

 

The have also setup a maintenance job on the sql server to re-index the database every Saturday night, again no improvement.

 

They have double checked any modifications we’ve had to NAV and confirmed that the coding is good.

 

Their hardware team has look over both servers to make sure there are no hardware faults and everything is fine.

 

They have noticed if they look at the sql activity monitor data that resource waits the network I/O times are high (their words not mine)

Wait Time (ms/sec) 6138

Recent wait time (ms/sec) 5851

Average waiter count 7.0

Cumulative wait time (sec) 175396

 

Other things I have noticed on this screen are loads of “ASYNC_NETWORK_IO” in the processes section that have a task state of suspended, no idea if this is normal or not, the support companies thoughts on these are it not related so we don’t need to look at it.

 

The support company have confirmed (at least that what they have said) it’s not a networking issue, when the service tier was on the sql server we pulled the network cable, create a local connection to the database, so no networks connected to the server and only one user connected to the database and the issue was still there.

 

Our current setup is:

NAV 2013 build 7.0.48066.0

 

SQL Server

Server 2008 R2 64 bit, 32GB RAM, single Xeon X5675 processor

C drive = OS, Raid 1

D drive = Log files, Raid 1

E drive = Database files, Raid 10

 

Service tier server

Server 2008 R2 64 bit, 28GB RAM, single Xeon E5649 processor

C drive = OS, Raid 1

D drive = random files not being accessed, Raid 1

 

NAV add-ons

Zetadocs capture

Zetadocs delivery

 

Many thanks


Mac

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Nav 2013 performance issues

    Might be for many reasons. There might be plenty of flowfields on the cards as Amol wrote. For troubleshooting purposes try taking off all flow fields from the fact boxes and page and then add them one by one to identify was that a problem or not. Try also to fire up trace flag 2371 in SQL to update statistics more frequently (as you have 2008 R2 version installed already).

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Nav 2013 performance issues

    Is it related to only master card or the documents also.

    Like Posted Sales Invoice, Posted Purchase Receipt etc.

    I would suggest you create a new page showing minimum information of customer and check.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Nav 2013 performance issues

    On Customer Card Check for flow fields. If have many flow fields it normally takes times to open the page 

    As well as check for any code written on On Open Trigger

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templates⚡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans