With many Microsoft Dynamics AX products coming to the end of their lifecyle within the next few years, most businesses will already have a plan to upgrade to Microsoft Dynamics 365. But what are you going to do until then?

How many years have you got left working with Microsoft Dynamics AX? One? Two? That’s a lot time when your in-house team are fed up with a slow, clunky system and you aren’t getting the results you need for business success. So what do you do?



It’s great that you have a plan to upgrade and that you’re thinking about the future of your business, but you need to act now to get the maximum from your existing systems. Don’t fall into the trap of thinking that there’s nothing that can be done, that your old Dynamics AX system just needs to limp along until it’s upgrade time.

We are leading specialists in Microsoft Dynamics AX optimisation, so we can unequivocally tell you that there is still plenty of life left in your Dynamics AX systems.

Last year we worked with a number of businesses, specifically retailers, to help them prepare for the Peak Period over Black Friday and Christmas. They needed to get their software running fast to deal with high volumes of traffic and to maximise sales opportunities. We found that there was huge potential for performance improvement, and this isn’t limited to just the retail sector.




1. Are you up to date? We can’t tell you the number of businesses we speak to who assure us they’re on the most recent version of their software, but when we check we often find there can be years’ worth of missed updates. While you can get away with skipping some application version upgrades, you should make sure you are as current as possible. By running outdated or unsupported versions, at best you’re slowing down your systems, and at worst jeopardising your business. It’s simply not worth the risk. Read our blog post on how to check what version you’re on and if it’s the most current one available.


2. Gather data. Install the Performance Analyzer for Microsoft Dynamics (DynamicsPerf 2.0). Get it setup and leave it for a few days to gather representative data. Once you’ve got some data from the analyser you can see if there are any gaps, forewarned is forearmed.


3. Identify long running queries. Long running queries are resource hungry and slow your system down, leading to poor performance and potentially a bad user experience. We’ve posted a blog post that shows you how to identify the top 25 long running queries. The result is a list of the longest running queries, grouped by unique stack trace and sorted by the average time that the query takes to run. The stack trace can be used to pinpoint why a query runs slowly. Once you’ve pinpointed the slow running queries you can identify ways performance can be improved, for example through code improvements or SQL maintenance.


4. Optimise your underlying systems. DynamicsPerf will give you a great insight into the overall performance of the Microsoft Dynamics AX application. However, the software will never run well if the underlying system is not optimised. Get started by installing the Performance Analysis of Logs (PAL) tool. We’ve covered a simple install and setup in an earlier blog post.



Have a look at our series of blog posts we posted to help support businesses in the run up to Peak Period last year, there’s a whole lot of hints and tips that will give you some quick wins, including more details on the points above. If you’ve gone through all our suggested easy fixes and could do with some more input, consider working with a partner to get expert help to maximise performance. You’ll be surprised at how a little investment can take your systems to extraordinary new levels of performance.


Don’t forget to Follow AgileCadence on LinkedIn for industry updates, news and more hints and tips.