Tune up AX performance in 9 steps – with Performance Tuning Pack

Performance Tuning Pack
Dynamics AX Databases

Custom callout image

Ensuring sufficient and stable AX performance in normal operating hours can be a serious topic, especially during traffic peaks (for example during Christmas).


The most important thing is experience
• with MS SQL
• with Dynamics AX
• with practical implementations

The ability to tune performance consists of perfect MS SQL knowledge (databases) and extensive experience with AX and its specific behavior. Plus we perform many hours of tuning and removing dead end solutions.


Read More!       Download PDF



Debugging process
• Setting target parameters
• Monitoring and testing
• Narrow spots analysis
• Debugging and optimization
• Repeated test and evaluation

Debugging is a discipline that consists of a number of key steps. It is necessary to set mutual expectations in the first place then our own monitoring tools do their job, evaluate the system operation and identify weak spots. Based on these information, an analysis and a repair process is performed either in AX settings or SQL and in the source code itself. This is followed by further testing along with analysis of the data acquired by monitoring.



  Process steps Timing
1 Common setting of goals, processes and critical spots of focus within debugging Day 1
2 Implementing database monitoring, probes and agents on servers Day 2
3 Monitoring process for at least 24 hours and collecting of data Day 3
4 Acquired data analysis Day 4
5 Elaboration of a report and recommendations based on the analysis Day 5
6 Presenting the results to the customer (2-4h) Day 6
7 Agreement on further progress (implementation extent) Day 6
8 Implementing the changes in top 3-5 performance issues
(Duration based on complexity and extent of the changes agreed)
Day 7 – Day 11
9 Repeated test and evaluation Day 12
Iteration of steps 7 – 9 according to agreement



We managed to remove long-term issues in one international retailer with 1.250 CCU AX and ensure sufficient performance during a period essential for its business.

Why should you trust us?
Because we have a lot of experience and know-how.

Every day we administer 1.000 SQL databases operated in 21 countries and ensure their flawless operation.


Selected references


Contact form

Your name and surname*
Attached file