Category: Microsoft Dynamics AX

Monitoring Microsoft Dynamics AX with Operations Manager enables administrators to proactively react to changes in the overall health of the AX environment and to adjust the system for optimal performance and reliability. With this management pack, operators and administrators can view information about all Application Object Server (AOS) instances in the environment, take AOS servers…

There is a performance issue in SQL Server 2016 and SQL Server 2017 where the processor utilization will run very high for certain queries https://support.microsoft.com/en-us/help/3216543/fix-many-consecutive-transactions-inserting-data-into-temp-table-in-sq The queries that will experience this higher utilization are queries that insert many records into a table or temp table OUTSIDE of a transaction. Not starting your own BEGIN/COMMIT transaction…

Introduction How to create good validation tests for your implementation. The scenario is – ‘You have an ISV who delivers you updates and you want to have an automatic validation that proves nothing has been broken’. In the test automation pyramid the tests described in this post are typically called ‘integration tests’. A quick search…

Microsoft Connect has been retired in favor of new tools and services to engage with Microsoft. If you are a member of an active Connect program, you should have received information on how to continue your engagement with these new platforms, including some that are related with Dynamics products: Microsoft Dynamics 365 The Dynamics 365…

A new platform version for Microsoft Dynamics 365 for Finance and Operations, Enterprise Edition has been released. To get more information about hotfixes included in this version (7.0.4641.16233 or August 2017 release), please view the KB article in Lifecycle Services (LCS). It’s interesting to note the new support for keyboard shortcut sequences in the browser client. The…

Hello, everyone! As many of you are already aware, SQL Server’s Cardinality Estimator received its first update in SQL Server 2014 (this was its first update since SQL Server 7.0), then again in SQL Server 2016. Many customers on Dynamics AX 2012 R3 who have upgraded to SQL Server 2016 and have changed the compatibility…

With Dynamiscs AX 2012, the concept of TempDB temporary tables was introduced to leverage the power of SQL Server. The TempDB database can store temporary tables as opposed to the traditional InMemory tables. But this technique might cause issues if the access to the TempDB database for the domain account running the AOS service is not correctly setup,…

Greetings, everyone! So there is likely some confusion as to whether or not IDMF is supported in SQL Server 2016. Some time in August of 2016, a blog was published about this topic. While this information held true at the time of its publication, there is new information surrounding this. In order for IDMF to…

Performance Analyzer for Microsoft Dynamics 2.0 has been posted DynamicsPerf 2.0 RTM. I would like to thank the entire Dynamics community and SQL DBAs that have helped during the process of building this new and exciting version of Performance Analyzer. Everyone in the community has done a great job of contributing to this version…