AX Performance Monitor 101 – Tips and tricks to deal with performance counter files

In my previous blog post, I explained how to setup Performance Monitor (PerfMon) to proactively capture performance data while cleaning old files to keep disk space under control. This is, let’s say, our ideal scenario, but sometimes setup is not that specific and we need to deal with suboptimal files that contains the performance data…


Monitoring Microsoft Dynamics AX 2012 R3 with System Center Operation Manager 2016

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…


High CPU Performance issue in SQL Server 2016/2017

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…


Using the Systest framework and Task Recorder in Dynamics 365 for Finance and Operations to create integration tests

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…


Did you check Resource Governor settings before starting your load testing?

Dynamics AX 365 For Operations is leveraging the Resource Governor available in SQL Server. But before we dive in, let’s first get the basics. What is the Resource Governor? In short the Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use. To…

2

Microsoft Connect Has Been Retired, how to find Dynamics downloads

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…


AX Performance Monitor 101 – Setup Perfmon for continuous monitoring with rolling files

  Windows Performance Monitor (PerfMon) is likely the most useful tool (together with our DynamicsPerf package) to monitor and diagnose performance problems related with your Microsoft Dynamics AX infrastructure and, in general, for any software running on Windows operating systems. Given its importance, is surprising how many people is not using it properly or, even worst, is not using…


DynamicsPerf 2.0 Nov. 2017 Patch is Released !!

With the move over to Github: https://github.com/PFEDynamics/DynamicsPerf , we have also posted a new patch for DynamicsPerf 2.0.   Highlights: New SSRS reports – Updated reports based on the INDEX_HISTORY table in DynamicsPerf New and improved sample queries .. .. Improved collection to better limit the SIZE of DynamicsPerf  !!   We have been testing…


New HOME for DynamicsPerf !!!!

With codeplex shutting down, we have moved DynamicsPerf over to Github.   You can find the download at:  https://github.com/PFEDynamics/DynamicsPerf   Rod “Hotrod” Hansen


Embedded Power BI: Interactive integration with Dynamics 365 for Finance and Operations

Introduction In this blog post we’ll look at the integration between Dynamics 365 for Finance and Operations and its embedded Power BI reports, specifically regarding drill-through and callbacks from Power BI to AX. Note This post will not cover authoring, embedding and securing the reports. This is not intended as full documentation of this feature,…