Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

Why does converting a report to pre-processing help to resolve timeout issues?

I assume you are familiar with the below post that contains detailed instructions for increasing relevant timeouts to enable long running reports to execute successfully. How To: Addressing SSRS Session Timeouts (Alternatively Tips to help prevent long-running reports from timing out [AX 2012]) The first recommendation in case of reports which use the Report Data… Read more

Configure SSRS for load balancing in your Azure deployment

Using the Cloud-hosted environment tool in Lifecycle Services, you can deploy a High Availability environment. When you deploy a High Availability environment, two BI servers are deployed by default. Each BI server has SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) configured as a unique local instance. Use the following information to… Read more

Troubleshooting that elusive “slowdown” in AX using Performance Analyzer 1.20 for Microsoft Dynamics

It’s 9.30am on Monday morning and you’ve just received reports of a “general slowdown” on Microsoft Dynamics AX. After probing further you find it was all over by 9:15am lasting around 15 minutes, but also happened once before and the users want action taken to prevent it happening again. There are never any guarantees when… Read more

AX Performance Troubleshooting Checklist Part 2

This is Part 2 of a two part troubleshooting check list for general performance on Microsoft Dynamics AX. This part includes  hardware, indexing, queries,  blocking and code – at a high level. Please note this is just an outline of key areas for general guidance and not an exhaustive list. As you have landed here,… Read more

AX Content: The Compare Tool works with SSRS reports

With cumulative update 7 for Microsoft Dynamics AX 2012 R2, the Compare Tool has been updated to support comparison of two SSRS report designs. This means that when an updated report is released with a cumulative update or hotfix, you can now easily compare the updated report with your existing report to see the differences… Read more

AX Content: Warm up those SSRS servers

Microsoft SQL Server Reporting Services periodically restarts, and each restart clears the Reporting Services cache. After this cache has been cleared, it may take some time for the next report that is run to display. For example, you may have noticed that it takes a really long time for the first report that is run… Read more

AX Content: Multiple instances of SQL Server Reporting Services (SSRS) on one computer

Do you have multiple instances of SQL Server Reporting Services that run on the same computer? Do you want to integrate those instances with Microsoft Dynamics AX? If so, a Windows PowerShell command is now available with cumulative update 7 for Microsoft Dynamics AX 2012 R2 that makes the integration process a whole lot easier! … Read more

Microsoft Dynamics AX 2012 Reporting – tips how to improve performance

There are some tips we can use to improve performance of reports for Dynamics AX 2012. Use static reports. The deployment of static reports is described here: In this way we will safe several calls to Metadata service to get labels values and correct formatting of dates and numbers. Install application hotfix KB 2879661… Read more

We want to hear from you! Participate in the Microsoft Dynamics AX product suggestions program

Make your opinion count! Give us your product suggestions and help to make future versions of the Microsoft Dynamics AX applications better. Use this Microsoft Connect site to submit your product suggestions for Microsoft Dynamics products. Search existing suggestions and vote on suggestions submitted by others. Your feedback counts – future versions and enhancements of… Read more

AX 2012 Pre-requisite checker sees both the OLD SQL and the upgraded SQL instance.

Issue – I have a sql server that we have upgrade from SQL 2008 R2 to SQL 2012 SP1 and am attempting to install the AX 2012 R2 report extenstions. The pre-req checker recognizes both SQL 2012 and SQL 2008, even though SQL 2008 has been upgraded to SQL 2012 and no SQL 2008 instances are… Read more