Announcing RAP as a Service for Dynamics AX

I am pleased to announce the General Availability of RAP as a Service for Dynamics AX.  This Microsoft Premier Service takes our existing Health Check to the next level with on-demand data collection and analysis to give you the flexibility to check and re-check the state of your system whenever you want as many times…


Dynamics AX is crashing what should I do? VIDEO

If your Microsoft Dynamics AX application ever crashes then you should know what troubleshooting steps to take to find out why this exception has occurred. Please see the attached videos recorded by one of our Escalation Engineer’s from the Support team.   The first video includes information about; What is a crash? The second video includes information…


Dynamics AX 2012 Cumulative Update 7 (CU7) is now released!

In case you missed it, I’m happy to relay we recently released Dynamics AX 2012 R2 Cumulative Update 7! CU7 includes enhancements to several modules or feature areas, including the highly anticipated Data import, export, migration improvements, and integration with Lifecycle services. AX 2012 R2 CU7 is posted as KB number 2885603, build number 6.2.1000.4051….

5

Critical issue in SQL Server 2012 Service Pack 1 that could crash your SQL server

There is a known issue with SQL Server 2012 Service Pack 1 that everyone should be aware of.  If you have installed Service Pack 1 not part of a slipstream install, the registry on your SQL server could reach the 2GB limit and crash your SQL Server.  To avoid this issue for Dynamics products it…

1

Improve performance of your external applications querying Dynamics AX

Are you having performance issues with some of your external applications extracting data from Dynamics AX?   There are some rules in writing queries for Dynamics AX that you need to be aware.  These rules are implemented in Dynamics AX by the kernel when it executes queries against your SQL Server database.  The rule is…


Improving performance in the DynamicsPerf benchmark sample queries

In Performance Analyzer for Microsoft Dynamics, we a script called 7-Benchmark Queries.  The first set of sample queries in this script helps you answer the questions “What change?”.  It does this by showing you the hourly difference in row counts on your tables.    As part of developing our next version of Performance Analyzer for…


Management Reporter 2012 CU7 Release Review

Management Reporter 2012 CU7 is now available. This release, which has been posted for download, includes the ability to drill back to Dynamics from the Management Reporter Web Viewer, currency translation for Dynamics AX 2012 customers, plus a few more enhancements. Here’s a summary of the new Management Reporter CU7 features: Ability to drill back…

1

Management Reporter 2012 Introduction + CU6 Release Review

It has come to my attention that Microsoft will be deprecating financial statement report design functionality/features from future releases of Dynamics AX and relying more on Management Reporter 2012 to replace these deprecations that currently reside in the General ledger module of Dynamics AX.  Microsoft is moving quickly on their initiative to establish Management Reporter…


What is my data distribution by company(PARTITON and or DATAAREAID) for a specific Dynamics AX table?

  If you have ever asked yourself the question “What is my data distribution by company(PARTITION an or DATAAREAID) for a specific Dynamics AX table?”, wonder no longer.  Attached is a TSQL Stored Procedure you can add to your Dynamics AX database (4.0, 2009, 2012, 2012 R2…) and then run it against any table in…

4

Benchmark your Dynamics AX solution with Load Testing

One of the most crucial time when implementing your Dynamics AX solution is the few weeks prior the Go Live. At that stage, the infrastructure has been configured with all components and all settings have been reviewed to match best practices. The functional team is running all test cases to sign off all design changes…


SQL Server Trace Flag 2371 for Dynamics AX

In my travels around the country from one Dynamics AX customer to another the customer is usually aware of how important database Statistics are to the overall performance of Dynamics AX.  The one thing I do not find though is Trace Flag 2371 enabled (or even know that it exists) or an in-depth understanding of…

5

Dynamics AX, Index Fragmentation, and You.

I have been onsite at a lot of Customers who believe that Index Fragmentation is major influence on overall Performance for Dynamics AX.  I actually have a hard time convincing them that its impact is relatively low on overall performance.  They also raise the issue that they can no longer fit their re-index job into…

3

AX ERD site for AX 2012 R2 is here!!

Hi Everyone – I wanted to put this site out on the blog for everyone who is not yet familiar with it.  As we all know there were a lot a table structure changes to AX 2012 from AX 2009. I hope that the ERD diagrams on this site will help us all navigate the…


Payroll for Dynamics AX: Enabling Tax Engine Debugging

The Tax Engine for Payroll for Dynamics AX has a logging capability for debugging that is very helpful for debugging tax issues and seeing specifically what Dynamics AX is sending into the tax engine. The logging capability allows you to debug what values are being sent to the tax engine, what calls are being made,…

1

Payroll for Dynamics AX: New Tax Updates available (2013)

New tax updates for Payroll for Dynamics AX are available for download. Find the latest updates at the links below. Enjoy! Microsoft Dynamics AX 2012 US Payroll The AX 2012 Payroll tax update 2013-R11 contains the updated tax engine. AX 2012 Payroll tax update 2013-R11 now available (KB2872380) – PartnerSource AX 2012 Payroll tax update 2013-R11…


Top 10 issues discovered from Dynamics AX Health Check

The Premier Field Engineer team has been running several hundred of Dynamics AX Health Check worldwide and I thought it would be interested to share the most common issues discovered during onsite. Some of the following issues might look trivial but the reality is that despite all the literature that exists today on the solution…


Do not assume, Benchmark your X++ code

Some might argue Dynamics AX is an opened source ERP. With the developer license, you can see the whole stack of Microsoft code (SYS and SYP layers), and you can overwrite its core business logic to match your specific needs (VAR or CUS layers). That flexibility is maybe the number one strength of the product,…


Performance Analyzer 1.16 for Microsoft Dynamics IS HERE !!

You can download the latest release of Performance Analyzer 1.16 for Microsoft Dynamics at the following:  http://dynamicsperf.codeplex.com.   This release officially supports SQL Server 2012 and all currently released Dynamics Products.  There have been several performance improvements incorporated into this version especially around analyzing QUERY data.  For the operational staff, we have enhanced the QUICK…

5

Dynamics AX 2012 and SQL Server 2012 AlwaysOn Availability Groups

When setting up Microsoft SQL Server 2012 AlwaysOn Availability Groups with Microsoft Dynamics AX 2012 you may run into an issue when attempt to enable the “Partial Containment” option on the Dynamics AX production database, which is a pre-requisite for AlwaysOn. Written by Michael DeVoe When you attempt to enable “Partial Containment” on the Dynamics…