Dynamics Ax Performance Team Blog

Multiple new Benchmarks released: Microsoft Dynamics AX 2012 R2 Multiple Retail Workloads, Microsoft Dynamics AX 2012 R3 Financial Benchmark, Microsoft Dynamics AX 2012 R3 Day in the Life Benchmark for Retail and Distribution

We are happy to announce that the following benchmarks will be available, just in time for Tech...

Author: Ch. Wolf Date: 01/05/2015

Improving SSRS Report Performance using new R3 features - Part 6

Using SrsReportDataProviderPreProcessTempDB class In Ax2012, we introduced class...

Author: Youxuan Jin Date: 05/06/2014

Overcoming parameter sniffing issue in Microsoft Dynamics AX 2012-R2 – CU6

Parameter sniffing is the default behavior that SQL Server uses when compiling parameterized SQL...

Author: Ganas1 Date: 07/29/2013

Improving SSRS Report Performance at Line level – Part 5

Inevitably, we can’t completely get rid of all line-based data accesses or calculations. So,...

Author: Youxuan Jin Date: 07/26/2013

Improving SSRS Report Performance with Hybrid of Line-based and Set-based Processing – Part 4

This pattern applies to a wide range of reports. It is the most applied pattern so far as based on...

Author: Youxuan Jin Date: 07/23/2013

Improving SSRS Query-based Report Performance by not Using Display Methods - Part 3

This post is about Query based reports in Ax2012. Ax2012 supports table display method in query...

Author: Youxuan Jin Date: 07/23/2013

Improving SSRS Report Performance by Applying Filters/Ranges Earlier - Part 2

We post it second because it is a low hanging fruit for better performance. One example helps...

Author: Youxuan Jin Date: 07/19/2013

Improving SSRS Report Performance with Set-Based Operations - part 1

Introduction Ax reports were migrated to Microsoft SSRS in Ax2012, mostly in the form of Report Data...

Author: Youxuan Jin Date: 07/19/2013

Improve Check Report Performance by Reducing the Size of Company Logo and Signature Image Files

Microsoft Dynamics AX 2012 uses SSRS as its report engine. For each data source in a report, SSRS...

Author: Ch. Wolf Date: 07/19/2013

Retail Benchmark Summary and Detailed Results published

In 2012, Microsoft conducted a benchmark on Microsoft Dynamics AX 2012 to measure the performance...

Author: Ch. Wolf Date: 10/18/2012

Microsoft Dynamics AX 2012 Benchmarks: Hyper-V, EP, and High-volume Inventory

We are happy to announce that the following benchmarks will be available, just in time for...

Author: Tao Wang - Microsoft Dynamics AX Date: 03/16/2012

Batch Parallelism in AX – Part - IV

  Comparison of the three techniques: Even Work Load: Invoicing of 100,000 single line Sales...

Author: Ganas1 Date: 03/01/2012

Batch Parallelism in AX – Part - III

  Top Picking: The issue we have seen with bundling is uneven distribution of the...

Author: Ganas1 Date: 02/28/2012

Batch Parallelism in AX – Part - II

  Individual Task Modeling Here in this case parallelism is achieved by creating a separate...

Author: Ganas1 Date: 02/24/2012

Batch Parallelism in AX –Part - I

  Dynamics AX 2012 and AX 2009 have the ability to breakdown a batch job into small manageable...

Author: Ganas1 Date: 02/24/2012

Dynamics AX 2012: Forms on opening hide behind in the back

  In Dynamics AX 2012, when you open the forms,  you might see some of them open behind...

Author: Ganas1 Date: 02/09/2012

AX 2012: Data upgrade best practices

We have published a white paper on data upgrade best practices. The white paper includes many...

Author: Tao Wang - Microsoft Dynamics AX Date: 01/10/2012

Using SysGlobalObjectCache (SGOC) and understanding it’s performance implications

  The SGOC is a kernel-managed cache. This is a new type of cache available in Dynamics AX...

Author: Ganas1 Date: 12/29/2011

Collect AX 2012 event traces with Windows Performance Monitor

Users can collect AX 2012 event traces with the Tracing Cockpit tool (see previous posting), the...

Author: Sam Peng Date: 11/18/2011

Microsoft Dynamics AX 2012: Client Performance Options

  Microsoft Dynamics AX 2012 includes many UX enhancements, such as list pages, ribbons, fact...

Author: Tao Wang - Microsoft Dynamics AX Date: 11/07/2011

“Day in the Life Benchmark” available for Download on PartnerSource and CustomerSource.

As of now the “Day in the Life Benchmark” for Microsoft Dynamics AX 2012 is available...

Author: Ch. Wolf Date: 10/26/2011

Client Access Log (Dynamics AX 2012)

Keeping track of multiple users’ activities as they do their work in the system is of great...

Author: Sellakumaran Kanagarathnam Date: 10/14/2011

Microsoft Dynamics AX 2012 Trace Parser is now available for AX 2009 customers

We want to make Microsoft Dynamics AX 2012 Trace Parser (Trace Parser 2012) available for AX 2009...

Author: Sam Peng Date: 10/11/2011

Consider Enabling Trace Flag 1117 on Dynamics AX SQL Server

Correct configuration of the tempdb database is crucial for Dynamics AX workloads. Two of the key...

Author: davidre_msft Date: 09/12/2011

Improvements on the global methods buf2con and con2buf in Microsoft Dynamics AX 2012

The global methods buf2con and con2buf are used on X++ to convert table buffers into containers and...

Author: Andres Martinez Andrade Date: 09/07/2011

Walk through major features of Microsoft Dynamics AX 2012 Trace Parser (Part 2)

Analyze traces Open Traces Once a trace file is imported, it is automatically opened in Trace...

Author: Sam Peng Date: 09/06/2011

Walk through major features of Microsoft Dynamics AX 2012 Trace Parser (Part 1)

Microsoft Dynamics AX 2012 Trace Parser is a performance analyzer that helps users discover and...

Author: Tao Wang - Microsoft Dynamics AX Date: 08/15/2011

Dynamics AX 2012 is generally available

As of August 1, 2011, Microsoft Dynamics AX 2012 is generally available in25 countries and 23...

Author: Tao Wang - Microsoft Dynamics AX Date: 08/03/2011

Video: How to collect a trace within Dynamics AX

My name is Ray Bennett, and I am formerly a member of the AX Performance team. During my work with...

Author: Ray Bennett Date: 04/26/2011

Microsoft Dynamics AX Technical Conference 2011

Next year is an important milestone in the history of Microsoft Dynamics AX—this is our most...

Author: Tao Wang - Microsoft Dynamics AX Date: 08/11/2010

Cross Company - Part 1: Updated KB Article

A new KB article now supersedes the previous one in the original of this post. Here is the link:...

Author: Mark Prazak Date: 07/06/2010

Dynamics AX Trace Parser Update 2

We have just released an update to Trace Parser with a lot of bug fixes. You can get it off from...

Author: Ray Bennett Date: 05/12/2010

Cross Company - Part 1

There are important changes in the fix documented in Knowledge Base article 977326 that should...

Author: Mark Prazak Date: 04/13/2010

Minor Changes in Database Configuration Checklist for Dynamics AX

We have made minor but important modifications to the Database Configuration settings, which are...

Author: davidre Date: 06/23/2009

Create RecID index on tables with Created/Modified DateTime fields

In Dynamics AX 2009, if you use Microsoft SQL Server 2005 as the database, you should create RecID...

Author: Tao Wang - Microsoft Dynamics AX Date: 06/19/2009

Event Trace Parser Tool for Microsoft Dynamics AX Released

We have released the RTM version of Event Trace Parser Tool for Microsoft Dynamics AX (aka...

Author: Tao Wang - Microsoft Dynamics AX Date: 06/19/2009

Application Benchmark Toolkit for Microsoft Dynamics AX 2009

We have released the Benchmark Toolkit as an Open Source Project on CodePlex. You can use the...

Author: Ray Bennett Date: 03/18/2009

Trace Parser Release Candidate 2

Trace Parser has been updated with some new user-friendly UI changes as well as stability...

Author: Ray Bennett Date: 11/25/2008

Debugging X++ Object Leaks

One of the most important aspects of writing managed code that interacts with AX through the...

Author: MSDN Archive Date: 07/04/2008

Ax Database Configuration Checklist Part 2

NOTE: This section has been updated to include special considerations for running SQL Server on...

Author: davidre Date: 03/13/2008

Welcome -- Ax Database Configuration Checklist part 1

Welcome to the Dynamics Ax Performance Team's blog. We're putting together a team introduction and...

Author: davidre Date: 03/10/2008