Performance Tuning Pack for Dynamics AX Databases

One serious challenge can be maintaining the performance Microsoft Dynamics AX needs during normal operation, and especially during peak periods (such as Christmas).

Know-How

Experience is what matters most!

• with MS SQL
• with Dynamics AX
• with real-world implementations.

The ability to tune performance correctly comes from a combination of thorough knowledge of MS SQL (the database itself) and deep experience with Dynamics AX and its specific behavior. All of that has to be backed up by many hours of hands-on tuning and working through dead ends along the way.

More about the Performance Tuning Pack in the PDF

Process

Tuning is a discipline made up of several key steps. First, we need to clarify expectations. Then it's time for our own monitoring tools, which assess how the system is running and reveal bottlenecks. Based on those findings comes analysis and corrective steps – whether in AX configuration, SQL, or directly in the source code. Then comes retesting, along with an analysis of the data gathered through monitoring.

Tuning process • Defining target parameters • Deploying monitoring and testing • Analyzing bottlenecks • Tuning and optimization • Retesting and evaluation

Process StepTiming1Jointly defining the goal, approach, and critical areas to focus on during tuningDay 12Deploying database monitoring, probes, and agents on the serversDay 23Running the monitoring itself for at least 24 hours and collecting dataDay 34Analyzing the collected dataDay 45Preparing a report and a set of recommendations based on the analysisDay 56Presenting the results to the customer (2-4 hrs)Day 67Agreeing on next steps (scope of implementation)Day 68Implementing changes for the top 3-5 performance issues (duration depends on the complexity and scope of the agreed changes)Day 7 – Day 119Retesting and evaluationDay 12Steps 7 – 9 repeated as agreed

Experience

We managed to resolve years-long issues at a multinational retail chain running 1,250 CCU on AX and ensured sufficient performance during a period absolutely critical to its business.

Why should you trust us? Because we've already been through it and we know how it's done.

Every day, we look after 1,000 SQL databases running in twenty-one countries around the world and keep them running flawlessly.

Selected References