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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics getting slower
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dynamics getting slower

(6) ShareShare
ReportReport
Posted on by JM-26060904-0 60
Hello,
We are currently using Dynamics 365 with 10 AOS servers and approximately 500 to 700 concurrent users.
We are planning to migrate to the cloud in the coming months.
However, we are currently experiencing significant performance issues that progressively worsen over time.
 
We are restarting some AOS (where users are connected, we reserved some for batchs) every days...
There is a maintenance plan on SQL Server that rebuild/refresh bad indexes.
The servers are on a fresh new nutanix infrastructure.
And even with that, we are experiencing performance issues each days, it's happening, I think, often on afternoon...
 
EDIT : some precisions -> issues disapear after AOS reboots -> no cpu saturation but RAM is full
Do you have any clues?
Categories:
Dynamics 365 Finance
I have the same question (0)
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones&q... 5,010 Most Valuable Professional on at
    It's a really broad issue and should be investigated holistically. And should be investigated as part of your cloud transition, as it might follow you into the cloud.
    Denis wrote a really great article about how to manage it as a project: How to manage a Dynamics AX performance optimization project | Denis Trunin's X++ Programming Blog
     
    A maintenance plan is often not enough, and might impact performance negatively. Rebuilding indexes will impact performance and affect plans.
     
    One thing that we did when I last dealt with this kind of on-prem implementation (Mind you, AX2012 not D365 F&O), was to implement query store in SQL Server and look at signs of parameter sniffing. For example, as your transaction amount increases, it might pick up bad plans from other legal entities with fewer transactions.
     
    Another is to look at timings of batch jobs, and see if there is a correlation between slow batch jobs: Analysing Dynamics AX / Dynamics 365FO batch performance using Power BI | Denis Trunin's X++ Programming Blog
    One issue we had was that certain users started heavy batch jobs that affected other processes. Like a warehouse manager running heavy reports during 14:00'ish.
     
    Have you checked the load of the servers, and are you running the latest PU's?
     
    Other people here way more knowledgeable that me can chip in, but these are just the first things I wanted to investigate.
  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,538 Super User 2026 Season 1 on at
    Hi JM-26060904-0,
     
    To add to what Jonas said, a few suggestions on the same.
    1. Performance issues usually occurs due to peak CPU utilization and this could be because of Running batch jobs, forms (screens - standard or custom), Flighting services, interfaces etc. Through Environment log history in Dynamics Lifecycle Services (LCS), you can view slow running queries, current executing statements etc. that are causing performance issues.
     
    2. Also, check for custom indexes (if any) in case of slow running indexes etc. that consumes more space on the existing database and causing slow running SQL statements.
     
    3. Looking at the issues in hand would recommend you running these jobs
     https://<d365url>/?cmp=<cmpName>&SysClassRunner&cls=SysFlushAOD
     https://<d365url>/?cmp=<cmpName>&SysClassRunner&cls=SysFlushDictionary
     https://<d365url>/?cmp=<cmpName>&SysClassRunner&cls=SysFlushData
     
    4. Migrating to Cloud from On-Premise from Dynamics Lifecycle Services (LCS) refer to the link below.
    https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/move-on-prem-to-cloud
     
    5. Performance optimization techniques.
     
    6. The other tool which is really handy and which we have used in a lot of implementation and support projects is the SQL Execute tool.
    This is pretty handy to check for duplicate data and slow running queries on the application level.
     
    Would also highly recommend this tool to be implemented once you move to the Cloud version of D365 FO. ISM Monitoring and Telemetery tool. 
     
    Hope this helps. Happy to answer questions, if any.
     
  • JM-26060904-0 Profile Picture
    JM-26060904-0 60 on at
    hi thanks for the answers. I got some question :
    We saw that everything is getting slow when some AOSs are getting low in memory. For example, 2 AOS are using +90% of the server memory.
     
    Why everything is slow while only 2 of our 10 AOS are full of memory ?
    How to get the cause of that memory consumption ?
     
    Sorry we are very noob in D365, the personn who set it has left the company and now we are a little blind...
     
    Hello
    Thank you for the answer.
     
    We have AOS dedicated to Batchs and AOS dedicated to users on differents servers.
    99% of the time, the issue is on the users AOS. Batchs are OK BUT everything is slow down, that's very strange.
     
  • Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,538 Super User 2026 Season 1 on at
    Hi JM26060904-0,
     
    Would recommend having dedicated components allocated to dedicated AOS Services. For example, you can have a batch only and interactive-only AOS Nodes in On-Premise deployments. For existing deployments refer to the documentation link for having Batch only and Interactive-only AOS nodes added to an existing deployment.

    Similarly, you can have dedicated AOS services allocated to SSRS Reporting services.
     
     
     
    Hope this helps. 
     
     
  • JM-26060904-0 Profile Picture
    JM-26060904-0 60 on at
     
    It's already the case, we are using dedicated AOS for batchs and users. it's seems that the interactive AOS are the most impacted by the issue.
    What we cannot find, it's how to find the cause of the consumption.
     
    For example : we are restarting all the 10 AOS each night arround 3:00 and we have report from users of slowness arround 9:00.
    After a check on the supervision we can see that CPU is heavy loading and the RAM is more 90% used.
     
    It happens randomly on the AOS and only on interactive AOS.
     
    Version is : 10.0.43
     
     
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones&q... 5,010 Most Valuable Professional on at
    It's a bit odd that it's all the user AOS's at the same time, and it's fixed by a reboot.
    Performance issues can be difficult to pinpoint without having access to the application. For example, we had issues with the Exflow web component completely saturating our user AOS's.
     
    It must be some sort of memory leak... I've seen a few issues related to it in the issue search.
    Sorry if I'm repeating myself, but are you on the latest platform update?
  • JM-26060904-0 Profile Picture
    JM-26060904-0 60 on at
    Hi @Jonas "Jones" Melgaard, we are on 1.0.43 version, platform : Update67
     
    Here a screen of our supervision (col are hostname,graph CPU, % CPU, memory % used) :
    AOS 8 & 9 are none user AOS so only users AOS have the issue.
    Each AOS have 24 cores and 64 GB or RAM...
  • Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 2,538 Super User 2026 Season 1 on at
    Hi JM26060904-0,
     
    Thanks for sharing the throttling information. 
     
    Looking at the throttling it looks like there are some long running SQL Statements in the environment log history that is causing the AOS memory consumption to shoot up. Is it possible to share the details which table(s) are triggered in these slow running queries/requests throttled/slow interactions?
     
     
     
  • JM-26060904-0 Profile Picture
    JM-26060904-0 60 on at
    how did you get that screen ?
     
    We are onpremise, I am not aware of those kind of tools. We are using ssms.
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones&q... 5,010 Most Valuable Professional on at
    @JM-26060904-0 this is from LCS, you will get access to these tools when you move to the cloud.
    I'm 99% sure on-premise deployments don't stream log events to LCS. But others can correct me.
     
    Instead, you can use the on-premise diagnostics tools, that I hope you have installed.
    You should be able to see something similar than LCS: On-premises diagnostics - Finance & Operations | Dynamics 365 | Microsoft Learn

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 616

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 460 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 331 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans