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…

0

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…

0

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…

0

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,…


Backup and Restore Strategy for Dynamics AX

Your organization’s deployment of Dynamics AX is going to be one of the most important applications in your enterprise (if not, it is the most important application).  It is absolutely critical to the health of your business that a sound backup and restore strategy is in place for your implementation of Dynamics AX. Ensure that…


Management Reporter Version/Feature/ERP Compatibility Overview

The quarterly RU/CU releases of Management Reporter, over the last five(5) years have introduced many new features and supported scenarios. To help you and your team, the MR Program Management and Customer Service teams have created a summary cheat sheet that covers what version contains a feature a customer is interested in and the Dynamics…

7