After Microsoft Dynamics AX is implemented, it is very important to keep track of application performance with growing number of transactions and users accessing the application concurrently. Due to certain factors like incorrect hardware sizing, poorly written customization etc., the performance of application might be degraded that ultimately frustrates the users and hurts business operations. At this point, customer should either interact with the implementation partner or a partner who are expert in doing a thorough diagnostics of the application and help user bringing the operations to normal. In this post, we will briefly look at the some of the areas where a partner or customer technical team can deep dive in to get to the root cause and its resolution.
A good way to start the health check is to look at the hardware and infrastructure area. Current architecture and hardware sizing for Storage, SQL, AOS, RDS (if exist) and other servers can by analyzed along with network latency and bandwidth among them. This also covers the analysis of servers from disaster recovery and high availability point of view. If virtualization is in place, then a check on virtualization best practices needs to be done. Next you can look at Microsoft Dynamics AX application including AOS and client setup, AOS settings and application settings like configuration and security analysis. Another important area is query tuning where you can run analysis on long running queries and database indexing. If the customer has an ISV solution installed or there are customization developed, it is super important to analyze the custom code for best practices, standard coding patterns for MS Dynamics AX.
Database locking and blocking analysis is another important area that needs to be taken care of. It is usual that certain tables in Microsoft Dynamics AX grow faster as the business operations use the application. So finding out such tables and possibility of archiving or cleaning them up is something can be done with care. Moreover, integration of Microsoft Dynamics AX application with any third party application should also be analyzed. Often times, poorly written integration starts impacting the performance of AX application with excessive open connections and back n forth communication.
Microsoft provides some tools that really help diagnosing the performance problems. Performance Analysis of logs, performance analyzer, IDMF (intelligent data management framework), SCOM, Trace parser and code profiler are some of the tools that can be used. For its health check offering, AXPulse use these tools along with other custom develop tools and frameworks to analyze AX performance issues and overall application health for customers and partners.