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...

Date: 01/05/2015

Improving SSRS Report Performance using new R3 features - Part 6

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

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...

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,...

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...

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...

Date: 07/23/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...

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...

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...

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...

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...

Date: 03/01/2012

Batch Parallelism in AX – Part - III

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

Date: 02/28/2012

Batch Parallelism in AX – Part - II

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

Date: 08/15/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...

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...

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:...

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...

Date: 05/12/2010

Cross Company - Part 1

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

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...

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...

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...

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...

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...

Date: 11/25/2008

Debugging X++ Object Leaks

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

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...

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...

Date: 03/10/2008