513
Hi,
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,
Vignesh
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.
Hi Ashwin,
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.
Regards,
Vignesh
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:
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.
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.
Hi Vignesh,
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.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
