Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Full logging NAV -- Performance drain?

Posted on by Microsoft Employee

Hi,

  1. Is it possible to write the change logging of our system to a dedicated SQL server?
  2. How can we automatically archive our logging?
  3. What could happen if we change our logging configuration to fully log our system? (We are afraid for performance drains)
  4. Are there alternatives to fully log our system without having the danger the system will slow down

Regards,

 

 

Daniël 

*This post is locked for comments

  • Verified answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Full logging NAV -- Performance drain?

    for details about using the nav change log best follow www.archerpoint.com/.../setting-change-logs-microsoft-dynamics-nav-2013

    for sure activating the change log has an performance impact, but it depends on

    - the used hardware of the server, the database, the clients

    - the amount of transactions you have per day

    the only way to get experienced with activating the change log, simply give it a try. activate it for one week, then analyse the results. check how long do you wait when posting orders, viewing/printing reports, run jobs, ... compare the times with the same actions without change log. then you have your answer.

    and, at the end: ask yourself, why/if you really want/need the changelog. maybe there are other solutions for your concrete issue.

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