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…