Finance | Project Operations, Human Resources, ...

Dynamics getting slower

(3) Share

Report

Posted on by JM-26060904-0

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 or memory or disk

Do you have any clues?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (7)

Answers (0)

JM-26060904-0 on at

Like (0)

Report

Dynamics getting slower

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...

Was this reply helpful? Yes No
Jonas "Jones" Melgaard Super User 2025 Season 2 on at

Like (0)

Report

Dynamics getting slower

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?

Was this reply helpful? Yes No
JM-26060904-0 on at

Like (0)

Report

Dynamics getting slower

Hi @Navneeth Nagrajan

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

Was this reply helpful? Yes No
Navneeth Nagrajan Super User 2025 Season 2 on at

Like (0)

Report

Dynamics getting slower

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.

References:
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/onprem-batchonly

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/onprem-add-remove-node#add-a-node
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/deployment/onprem-ssrsha

Hope this helps.

Was this reply helpful? Yes No
JM-26060904-0 on at

Like (0)

Report

Dynamics getting slower

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...

@Jonas "Jones" Melgaard

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.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan Super User 2025 Season 2 on at

Like (0)

Report

Dynamics getting slower

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.

https://learn.microsoft.com/en-us/training/modules/apply-basic-performance-optimization-finance-operations/

https://github.com/MicrosoftDocs/dynamics365-guidance/blob/main/guidance/techtalks/finance-operations-continuous-number-sequence-performance-improvements.md

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.

https://denistrunin.com/xpptools-sqlexecute/

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.

https://github.com/microsoft/ISM-Telemetry-for-Finance-and-Operations

Hope this helps. Happy to answer questions, if any.

Was this reply helpful? Yes No
Jonas "Jones" Melgaard Super User 2025 Season 2 on at

Like (0)

Report

Dynamics getting slower

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.

Was this reply helpful? Yes No