Microsoft Dynamics AX Support

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

Optional Additional Installation Script for Blocking Analysis with DynamicsPerf v2.0

In relation to the analysis scripts that come with DynamicsPerf (Performance Analyzer) v2.0, (based on the new extended events being used in place of the SQL profiler trace which featured in v1.20), i.e.: … —            BLOCKING_EVENTS — Blocking events sorted by TIME desc —————————————————————- SELECT TOP 100 * FROM (SELECT event_data.value(‘(event/@name)[1]’, ‘varchar(50)’) AS EVENT_NAME, DATEADD(hh, DATEDIFF(hh,… Read more

Check AOS event logs and SQL Server error logs for key messages using DynamicsPerf

As part of general monitoring of Dynamics AX overall system health and/or troubleshooting, you’ll want to check the Windows event logs in your AOS server(s) and SQL Server error logs. If you have DynamicsPerf (Performance Analyzer for Microsoft Dynamics) installed, you can quickly check for key messages and if necessary, export and move them all… Read more

How to proactively avoid parameter sniffing step-by-step

In the following blog post the so called „parameter sniffing“ is explained: http://blogs.msdn.com/b/axinthefield/archive/2014/01/09/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil.aspx The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d… Read more

Calling AX 2012 Business Logic from SSIS Using a Script Task and Custom Web Service

This relatively simple example demonstrates how you can call AX business logic from SSIS by connecting to a custom web service. It assumes some knowledge of the individual technologies themselves. The underlying business logic for our custom web service in AX 2012 returns a message based on a parameter of type integer passed into it… Read more

AX Performance – What information and data to collect when you want to open a support case

The aim of this blog post is to provide you with some suggestions on what information and data to collect and provide when opening a Microsoft support case. You can of course use these suggestions in your own organization too, whether you are a Partner or End User of Microsoft Dynamics AX. It’s usually a… Read more

AX Performance – Analyzing key SQL Server configuration and database settings

In the previous post in this series, I provided some T-SQL scripts that can check key settings and highlight possible issues you need to address. This post aims to provide some feedback and suggestions on the information the scripts collect. There are of course different views on almost all SQL Server configuration settings, but the… Read more

AX Performance – Checking key SQL Server configuration and database settings

It’s important to configure your SQL Server instance and your AX databases properly in order to achieve optimal performance on your Dynamics AX environment. This blog post aims to help you do that by providing some T-SQL scripts that can check key settings and highlight possible issues you need to address. The scripts don’t cover all… 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

Collect a series of traces automatically with Dynamics AX 2012

Introduction The following steps are one way to collect a series of AX traces on a schedule with all versions of AX 2012 on the AOS server, using standard Windows tools: Perfmon combined with Task Scheduler. This example collects a 1 minute trace at 5 minute intervals. This can be useful for example if you… Read more

AX Performance Troubleshooting Checklist Part 2

Updated on 09/09/16 for DynamicsPerf v2.0. 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… Read more