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.
- 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
|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.