Performance Tuning Pack for Dynamics AX database
One serious issue may be maintaining the necessary power Microsoft Dynamics AX in normal traffic and especially at peak times (e.g. during Christmas).
Knowledge
The main thing is experience!
- with MS SQL
- s Dynamics AX
- with practical implementations.
The ability to tune performance correctly is a combination of perfect knowledge of MS SQL (i.e. the database) and deep experience with Dynamics AX and its specific behavior. All this must be complemented by many hours of hands-on tuning and closing solution dead ends.
More about Performance Tuning Pack in PDF
Process
Tuning is a discipline that consists of several key steps. First we need to clarify expectations, then our own monitoring tools come in to evaluate the system and show us bottlenecks. On the basis of the information found, analysis and corrective action is taken, whether in AX settings, SQL or directly in the source code. Then comes the re-testing along with the analysis of the monitoring data.
Tuning process - Determination of target parameters - Deployment of monitoring and test - Bottleneck analysis - Tuning and optimization - Retest and evaluation
| Process steps | Timing | |
| 1 | Joint determination of the goal, progress and critical points for focus in the tuning process | Day 1 |
| 2 | Implementation of database, probe and agent monitoring on servers | Day 2 |
| 3 | Running the monitoring itself for a minimum of 24 hours and collecting the data | Day 3 |
| 4 | Analysis of the collected data | Day 4 |
| 5 | Preparation of a report and a set of recommendations based on the analysis | Day 5 |
| 6 | Presentation of results to the customer (2-4 hours) | Day 6 |
| 7 | Agreement on the way forward (scope of implementation) | Day 6 |
| 8 | Implementation of changes for top 3-5 performance issues (Duration depending on complexity and scope of agreed changes) | Day 7 - Day 11 |
| 9 | Re-test and evaluation | Day 12 |
| Iteration of steps 7 - 9 by agreement |
Experience
We were able to eliminate several years of difficulties in a multinational retail chain with 1,250 CCU AX and ensure sufficient performance in a period absolutely critical for its business.
Why should you trust us? Because we've done it before and we know how to do it.
Every day we take care of 1,000 SQL databases operating in twenty-one countries around the world and ensure their flawless operation.
Selected references
