Management Reporter Version/Feature/ERP Compatibility Overview

The quarterly RU/CU releases of Management Reporter, over the last two(2) 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…

6

DynamicsPerf Deep Dive – Baselines

  In this article, I will talk about Baseline support in DynamicsPerf and how you can use it to resolve performance issues.  Originally, when I was first thinking about Baselines, it was from the perspective of comparing DEV/TEST to Production environments.  But the issue we have right now is that we cannot collect from multiple…

4

SQL Server Always On Not Synchronizing after installing cumulative updates

I wanted to make everyone aware that there is an Always On bug in SQL 2012 SP2 CU3 and CU4 and SQL 2014 CU5.   You can find the article and fix here: https://support.microsoft.com/en-us/kb/3033492   If there are no other critical updates that you may need, it would be suggested to wait until the next round…

3

Statistical oddities when SQL returns more rows after archiving data

  I was recently doing a performance review for a customer when I ran across something very interesting.  The customer is using IDMF to archive data so I know that occasionally the record counts in a few inventory tables goes down.  In reviewing data in DynamicsPerf, I was reviewing all the SQL queries with multiple…