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