2,255
Hello all,
some reports in AX 2012 takes a lot of time to process. (like Inventory value or product base data)
I checked the CPU usage and it take only 2% of the cup power.
is there any way to make it use more cup power?
I'm in AX 2012 R3 CU12
*This post is locked for comments
If you experience any kind of slowness in AX including reports, that is rarely related to CPU/Memory issues. In 99% of the cases it is linked to SQL Server, or code design problems.
Make sure you have regular index/statistics maintenance, SQL Trace flags are set as per the recommendation for Dynamics AX, your disk layout for data and log files and number of TempDB files per NUMA core are correctly created, etc.
As for the code design, Crispin has already mentioned the possible solutions. If you feel that a particular report is slow because it is query-based, or using temporary tables, try optimizing/redesigning it, or convert it to pre-processed report.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
