Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / General low performanc...
Microsoft Dynamics NAV (Archived)

General low performance on Navision 2009

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all of you,

General low performance in our Always On Prod. I am stuck I don’t know what else need I check

Can you kindly address me on how to grasp more info?

Facts:

Flavour: Navision 2009

SQL figures: 32 Gb Ram, 8 cores. Xeon CPU E5-2690 v3

OS: Win 2012 R2 DataCenter

Manufacturer: Vmware

Storage: Mixed SAS with SSD

Number of Navision implementations:  13

Total Navision “User tables”: 27000

 Keep in mind:

-SP1 is still not applied :-(..   although I don’t think it could be very helpful in this case.

-Rebuild/Reorganize on weekly basis (Ola Hallengren’s stuff)

-TempDb is not splitted into more than 1 file as opposed we have got with AX in other location

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: General low performance on Navision 2009

    it is not applicable in our environment they run Classic client.

    thanks anyway

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: General low performance on Navision 2009

    automatic cost adjustment is day in our DBs

    not always

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: General low performance on Navision 2009

    thanks for your comments. VMWare stuff was properly deployed from the beggining.

    I have to come the conclusion that main problem here is the huge number of connections and the number of customizations done... I think against that, it's very tricky to sort out

    Thanks indeed

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: General low performance on Navision 2009

    thanks, just move these questions to one of our Navision contractors

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: General low performance on Navision 2009

    Look at the following link

    www.archerpoint.com/.../performance-tuning-microsoft-dynamics-nav-2009-and-nav-2013

    msdn.microsoft.com/.../dd338955.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: General low performance on Navision 2009

    Thanks in advance

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: General low performance on Navision 2009

    Are you having your SQL database on a virtual machine? If so check the settings and ensure that the access to the disk is set from normal to high priority.

    Otherwise, there might be many reasons. Check what are the customizations done to the database, especially the added fields and the logic that is put on those. Perchance there has been added weird flowfields that has too complex logic. Or, any batch jobs running in parallel with what users are doing.

    Refer also here:

    https://community.dynamics.com/nav/f/34/t/124547

    community.dynamics.com/.../506165

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: General low performance on Navision 2009

    What is your database Size? How many people are connecting to production database?

    Is there any specific processes taking longer time?

    Are you using Analysis by Dimensions having "Update on Posting" setup TRUE or

    Inventory Setup > "Automatic Cost Adjustment" = Always?

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: General low performance on Navision 2009

    hi,

    look at this post on NAV team blog (with PDF)

    SQL Server reccomandations

    blogs.msdn.microsoft.com/.../microsoft-dynamics-navsql-server-configuration-recommendations

    msdn.microsoft.com/.../hh169233(v=nav.70).aspx

    Forum old posts (about lock & deadlocks issues)

    community.dynamics.com/.../124515

    community.dynamics.com/.../124547

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans