web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / SQL Performance Upgrad...
Microsoft Dynamics NAV (Archived)

SQL Performance Upgrades for between cumulative updates of NAV 2015

(0) ShareShare
ReportReport
Posted on by Nareshwar Raju Vane... 5,596

Hi all,

We are using NAV 2015 - UK, Cumulative Update 16. We see a terrible system-wide slowness and we are planning for an upgrade. I have gone through the cumulative update platform updates.

I just wanted to know more technical details of the following fixes.

Cumulative Update 25
* 381209 Performance issue with NAvSqlQueryCommand on high load.

Cumulative Update 24
* 380883 NST does not handle transient SQL errors properly.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    first install your nav 2015 version on a clean new server and make some performance tests to check, if you have the same situation. then install cu 24, make tests, install cu 25, make additional tests.

    to check the performance issues on your current system, run sql profiler and make some user tests, measure the runtimes for the sql commands to check which commands need most time to run.

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    also follow interesting posting nav-skills.com/.../nav2013r2-maintain-sift-index

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,096 on at

    I do not have either any access to additional materials, related to CU 24/25, so running as Jonathan suggested is the best option if you opt for CU updates.

    However, there might be other reasons for the performance degradation; e.g., blogs.msdn.microsoft.com/.../degraded-performance-on-dynamics-nav-and-the-sql-server-tokenandpermuserstore

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans