Skip to content
Microsoft Dynamics 365 Blog

Blog posts for AX2012 R3

SSRS Report label shown as @SYSxxxx in AX2012 

Here in this blog I will share two scenarios when this happening and basic troubleshooting steps when facing this issue. Issue: When you are rendering SSRS report, the data will load correctly, but all AX labels are not resolved: As we can see AOS has already processed the label resolve request, and all results has...Read more
  • 0 Comments

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
  • 0 Comments

Serialising containers in X++ 

A problem I’ve hit a few times during troubleshooting is transferring containers from one environment to another. Importing a whole 100GB database to be able to access the results of a report packed into a 20MB container seems like a bit of an overkill. So, a natural idea would be to save the container to...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 

Following on from my previous blog post regarding analysis scripts for the tool Performance Analyzer v1.20*, I am now publishing the scripts that come with the latest version, 2.0. (*Previous post: https://blogs.msdn.microsoft.com/axsupport/2014/08/31/microsoft-dynamics-ax-general-performance-analysis-scripts/) Download link: https://dynamicsperf.codeplex.com/ After downloading and extracting the tool from the above link, you can find these scripts in the following sub-folders: ..\DynamicsPerf\DynamicsPerf...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 10 

This is page 10 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 2 

This is page 2 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 3 

This is page 3 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 4 

This is page 4 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 5 

This is page 5 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking...Read more
  • 0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 6 

This is page 6 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking...Read more
  • 0 Comments