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