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

9. 6. 2020Karel Pecl

Performance Tuning Pack for Dynamics AX Databases

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!


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

Dynamics AX Performance Tuning Pack Blue Dynamic

Process steps
1Common setting of goals, processes and critical spots of focus within debuggingDay 1
2Implementing database monitoring, probes and agents on serversDay 2
3Monitoring process for at least 24 hours and collecting of dataDay 3
4Acquired data analysisDay 4
5Elaboration of a report and recommendations based on the analysisDay 5
6Presenting the results to the customer (2-4h)Day 6
7Agreement on further progress (implementation extent)Day 6
8Implementing the changes in top 3-5 performance issues
(Duration based on complexity and extent of the changes agreed)
Day 7 – Day 11
9Repeated test and evaluationDay 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

Dynamics AX references logos 1024x177 1 Blue Dynamic

Další články

Naši specialisté vám s Microsoft Dynamics 365 rádi pomohou

Zanechte nám na sebe kontakt a tým Blue Dynamic se vám během 48 hodin ozve.