You might have heard users complaining about the slow AX. For me, this is one of the most frequently encountered post implementation scenario. So, is Microsoft Dynamics a poorly designed application which ultimately ended up with a slow performance? In my opinion, the answer is no. Microsoft Dynamics AX has been designed considering the scalability as one of the core application design principle.
So, why actually AX becomes slow with the passage of time? There can be number of reasons behind it which can be related to hardware, software components or poorly designed customizations. Today, I am going to summarize the high-level things which you must check before further going into further detail analysis:
- Does your environment run periodic maintenance SQL Server and AX jobs? Periodic maintenance jobs can include index defragmentation, SQL Server database statistics update, database log clean up, inventory dimensions clean up etc. These are very important maintenance procedures and definitely have a positive impact on the overall application performance.
- Is your hardware sizing being appropriate? Use the Windows Performance Counters to sample the data for disk IO, network interface and processors to identify any hardware related issues.
- Is your tempDB sized properly? tempDB configuration plays a vital role in achieving the best possible performance out of AX. There are specific guidelines for configuring the tempDB for Microsoft Dynamics AX.
- Is your AOS, AX client and SQL Server databases are configured in accordance to the Microsoft suggested best practices?
- If you are using third-party Microsoft Dynamics AX add-ons or your AX is heavily customized then you must monitor for slow running database queries to identify missing indexes. You can use Microsoft DynamicPerf tool to identify the slow running queries and missing indexes.
AXPulse Consulting offers a specialized service named “Application Health Check”. As part of this service we perform the detailed analysis of your existing environment and prepare a report to identify the performance bottlenecks along with recommendations on how to resolve them.
If you are interested to know more about this service you can contact us at firstname.lastname@example.org