Hi. I am amidst AX upgrade project.
OS is getting upgraded from 2012 to 2016, SQL server is upgraded from 2012 business intelligence edition to 2016 standard. AX should be 2012 CU9. Operating systems as well as SQL servers have received necessary updates.
As a MS SQL specialist, I have been invited over to tell why AX is slow. I have no access to AX part, however when monitoring database, while running tasks that are reported as slow, the database resource utilization is constantly low - around 2-4% with no peaks whatsoever.
On the side of the database, I have tried everything possible including playing with MAXDOP despite MSFT recommendation, changing compat levels, enabling trace flag T4199 with no obvious pattern in terms of improvement or worsening after database settings change. All these observations (low utilization, no change in AX task runtimes after DB server settings change, ... ) lead me to conclusion that problems lies within AX, not a database. A SQL query that runs on old database server in 55 seconds is executed in 16-21 seconds on the new database server.
Are there any general areas to check to make AX put some load on the database server, in hope of tasks finishing faster?
Thanks
