DynamicsPerf 2.0 Deployment Guide

INTRODUCTION The tool DynamicsPerf (Performance Analyzer for Dynamics) is used by Microsoft Dynamics Support team, Premier Field Engineers and Product Group team members to diagnose performance issues with Dynamics products such as Dynamics AX and Dynamics CRM. IMPORTANT: The purpose of the Performance Analyzer is to be used on a continual basis so it is…

22

DynamicsPerf 2.0 Installation for Dynamics AX

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. Dynamicsperf-2-0-deployment-guide The Performance Analyzer is delivered as a SQL Server solution and consists of a number of collectors as SQL jobs, X++ classes, VB scripts and performance counters. It also includes a set of sample SQL scripts…

10

Management Reporter 2012 CU14 is now available!

Management Reporter 2012 CU14 RTM (version 2.12.14001.45) has been formally released and ready for customers to download.   CU14 contains the following functional enhancements: Report Options for Web Viewer (DDM only): Change Period and re-generate report from Web Viewer Keyboard accessibility for Drill to Dynamics (see below for more details)** Microsoft Dynamics AX 2012 enhancements for budget…


Batch scheduling example.

My colleague Tom Stumpf and I were recently discussing running processes in batch that require schedules that the batch framework does not provide out of the box. For instance the business scenario we discussed was running a process only on the last day of the month. I took a look at the SRSReportServerWarmup class to…


Management Reporter 2012 CU13 for Dynamics AX 2012 is now available!

A critical issue was found in CU13 that could impact any customer setting up a new Management Reporter installation and using SQL authentication. The original installation files have been removed from CustomerSource and a new set of installation files have been posted. The re-release also contains the hotfix for the web viewer scroll bar missing….

1

Harness the power of PowerShell and the Business Connector too.

Hi Everyone. My name is Jason Larson. I am a Premier Field Engineer with the Dynamics AX team in the central region. I was recently asked how we could compare data in a text file outside of AX with data in AX. The business scenario for the customer was to compare financial dimensions between ERP systems…

3

Top 10 tips to prepare your Dynamics AX 2012 Go Live – Series 3/3

Hi, This is the third and last part of “the top 10 recommendations” list to prepare a Microsoft Dynamics AX 2012 Go Live. 7. Prepare Windows Performance Monitoring for ETL trace We do not recommend to collect such Dynamics AX trace in production because it can generate a very large size file and eventually impact performance. Also…


Top 10 tips to prepare your Dynamics AX 2012 Go Live – Series 2/3

Hi, Let’s now have a look at the second part of “the top 10 recommendations” list to prepare a Microsoft Dynamics AX 2012 Go Live. 4. Review long running queries from Dynamics AX users This is my favourite tool when it comes to performance monitoring. Other tools will give you great insight for Expensive queries (DynamicsPerf)…


Top 10 tips to prepare your Dynamics AX 2012 Go Live – Series 1/3

When customer is starting a new Dynamics AX 2012 instance, Microsoft Premier Field Engineer are often asked to support them on-site in case something goes wrong. Because of wide nature of incidents, it is always necessary to setup the right tools in production to collect the relevant data and keep the system healthy. We also…


Management Reporter 2012 CU12 for Dynamics AX 2012 is now available

Management Reporter 2012 CU12 RTM (version 2.1.12000.26) has been formally released and ready for customers to download. Please NOTE that this is a Quality Release(QR) focusing on bug fixes only.   CU12 contains all of the enhancements and bug fixes from CU11 Hotfixes 1-4, including: Indication of currently active reporting tree node Added the ability to use…


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…


Management Reporter 2012 Security Review with AX 2012

Below is a fairly detailed review of how Management Reporter 2012 security (users and user roles) are derived and directly correlate from the users created and security permissions assigned in Microsoft Dynamics AX. This review will cover the following topics: •Adding users from AX 2012 •User is assigned an AX 2012 role that does not…

1

Lifecycle Services Diagnostics for Management Reporter and Microsoft Dynamics AX 2012

It is exciting to make you all aware that eight new diagnostics scripts are now included for AX2012 specific to GL and Budgeting that help identify data inconsistencies that cause issues for Management Reporter integrations and incorrect reporting results. These scripts check for invalid data within General Ledger and Budgeting that can cause MR 2012 reports to produce incorrect…


Management Reporter 2012 CU11 for Dynamics AX 2012 is now available (Hotfix 4 Update)

Management Reporter 2012 CU11 (version 2.1.11000.32) has been formally posted and ready for customers to download (NOTE: 4 Hotfixes have been released for this CU release. Please review the details of each Hotfix below).   *****CU11 Hotfix 4 is now available*****  A final optional hotfix rollup is now available for Management Reporter 2012 CU11. This hotfix contains…

11