Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Version - AX 2009 SP1
SQL Server - SQL Server 2008 R2
AX is getting slow at particular time everyday. What could be the reason for this issue?
We have taken below steps but still AX is getting slow.
1. Restarted service and checked
2. Deleted AUC file and checked
3. No batch is running.
4. No SQL transaction block.
5. AX and SQL Server performance is good.
Kindly suggest some solution here.
Thanks in advance and regards,
There might be a heavy query scheduled on SQL itself. Also check if you have a lot of number sequences which are set to be continuous and have an auto cleanup. In the last case, disable the auto clean up and schedule a batch task for it which runs outside of business hours.
Also a possible reason is a scan of anti-virus on the AOS machine(s). In that case reschedule it, cancel it or exclude the Dynamics server folder.
Thanks for your suggestion. I will check the same.
Something is certainly competing with the AOS for resources, if it's not reflecting in SQL the problem can be related to storage access.
It could be a process (like anti-virus scan as mentioned before) that is performing lots of access to the AOS disk or worse to the DB disk.
If you have AOS and DB in separated machines you also need to check if the DB machine is not the problem. SQL Server has a configuration to limit its memory use, you can try to use that to let more memory for the OS.
Also, if the AOS access the DB through your network, you can check the network traffic when the slowness happens.
Its probable that over time your system has got busier or has more data. therefore default settings that worked initially may not longer be appropriate and the system may need retuning, Maintenance may have slipped or never been undertaken e.g sql, logs, data.
TIt depends also on what is running slow. Are you using additional features such as intercomponay or more complex mrp, or heavy data updates. Is inventory close up to date. There may be inappropriate parameters which reflect when the workload increases. There are many things that generally may help form boosting hardware, updating kernel, patching windows and sql, cleaning up clients etc, its difficult to be prescriptive without an audit by Ax specialists to advise.
Normally slow downs are from sql blocks or batches running on ax. However since you have checked these i would suggest you check on the users at that time.
I would check the following:
Thanks for your response.
We have checked the anti virus scan scheduled time, it is not affecting system performance and we have monitored the network traffic as well, no problem with it.
Our client running ERP only for finance purpose. we are not using any complex queries here.
The performance issue is occurring everyday at particular time.
Thanks for your suggestion!
Thanks for your suggestion here!
1. Users are posting only normal Journals, invoice's in AX .
2. Need to check with user, is there any customized import is happening at that time.
3. About your 3rd point, I need to check with user.
You can also check the expensive queries running on SQL by the time of slowness.
Then, based on the query itself a developer can help you try to figure out what process is running that query.
You can also post the query on this thread, so we can try to help you too.
I shall monitor the same and get back to you. Thanks for your response.
Business Applications communities