Assessing your disk performance and your needs: Analyzing collected data (Part 2)

Welcome back to this blog series on how to assess your disk performance and your needs. In the second part of the series we will discuss how to read and analyze the collected data using some sample data.   Analyzing the collection   Alright, so we’ve created our collectors, automated it to run during that…


3 Powershell Scripts for Dynamics AX – Refresh, Report and Monitor

Some time back we talked about AX Data Refresh with Powershell. Today I wanted to talk about some AX Refresh changes and two new scripts AX Monitor and AX Report. Let’s go over some of the details. AX Refresh Works for AX 2009 and 2012. Works with multiple AX instances on the same box. It does…


DynamicsPerf 2.10 Installation for Dynamics 365 Local Business Data (On Prem) / Dynamics AX

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-10-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…


DynamicsPerf 2.10 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 365 Local Business Data (On Prem), Dynamics AX and Dynamics CRM. IMPORTANT: The purpose of the Performance Analyzer is to be used…


Release your Dynamics 365 for Finance and Operation packages to LCS with Azure DevOps Pipelines

The first automation task to close the continuous integration cycle in Dynamics 365 for Finance and Operations with Azure DevOps pipelines was released recently as described on the official announcement. These are some high-level instructions to set it up while the official documentation is released: Prerequisites To keep things simpler, these prerequisites should be prepared…


DynamicsPerf 2.10 Available !!!

It is with great pleasure to announce that DynamicsPerf 2.10 can be downloaded from here. There are several enhancements to this version: Added support for Dynamics 365 Local Business Data (aka On-Premise ) New AOTEXPORT class specifically for Dynamics 365 Added collectors for Dynamics 365/AX BatchJobHistory data Be able to determine if a batch job…


Consume Azure Machine Learning Services in Microsoft Dynamics 365 for Finance and Operations

Today, every business in every industry is looking to take advantage of the Artificial Intelligence, or AI, as a mandatory step in their digital transformation journey. The broad definition of AI is any technique that enables computers to mimic human behavior by allowing computers to learn by example. On the other hand, Machine Learning, is…

1

How to measure the performance of the Dynamics AX 2012 forms

When users complain about the performance of the system, sometimes it’s a challenge to measure the performance of the forms. If you want a quick measurement for what forms a user is using in the AX Client and tracking the form events triggered in the form (open, close), at what time, computer name, duration in…


Cost Saving Capabilities on Azure for Dynamics AX 2012 R3

How cost savings can be possible for Dynamics AX 2012  R3 VMs Azure Resource Manager (ARM) and classic deployment models (ASM) represent two different ways of deploying and managing your Azure solutions. You work with them through two different API sets, and the deployed resources can contain important differences. The two models are not compatible…


Create Microsoft Dynamics 365 for Finance and Operations – Extensibility requests in LCS

Some months ago, Microsoft Connect was retired in favor of new tools and services to engage with Microsoft. The only feature we were still missing is creating Extensibility support request to enable extension scenarios and this feature is now enabled in Lifecycle Services. Use the Support tile in your Dynamics 365 for Finance and Operations…


Dynamics 365 for Finance and Operations. Static IP Addresses?

We received many requests regarding the IP addresses used by production environments of Dynamics 365 for Finance and Operations in the cloud. There might be multiple reasons for those requests: configure services and devices, allow access from the company’s network or simply monitor the availability. This blog is written to demystify some wrong assumptions. Can…


Microsoft job openings!!!

We’re looking for great candidates to take on exciting and challenging Dynamics 365 PFE roles at Microsoft.  If you’re interested in joining Microsoft and becoming a member of a team that plays a key role with our Dynamics 365 customers, please consider the following positions.    Dynamics 365 Customer Engagement (CRM) Premier Field Engineer:   https://careers.microsoft.com/us/en/job/399057/SR-PFE…


Embrace the extensions mindset with Dynamics 365 for Finance and Operations #2 – SysExtension framework

In my previous post Embrace the extensions mindset with Dynamics 365 for Finance and Operations we reflected on some of the patterns we can leverage to create our customizations by using only non-intrusive changes based on a real example: Adding a new Number Sequence to a standard module. In particular, we discussed: Metadata Extensions —…


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…

1

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


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

Management Reporter 2012 CU16 +HFs is now available!

Management Reporter 2012 CU16 has been posted for download. This release includes the ability to use Management Reporter over HTTPS, and includes several quality fixes as well. NOTE:   CU16 will be the last formal CU release for Management Reporter 2012 for Dynamics AX 2012.   Here’s a summary of the new Management Reporter CU16 features: HTTPS…


Installing Hotfixes – Please use the Update Installer

Greetings, Dynamics community!  We’ve all been there.  You are trying to resolve a problem in your production Dynamics AX deployment.  You discover a hotfix in LCS that should resolve the issue.  You also discover that there are hundreds of axmodel files that are included in the hotfix. The clock is ticking and the pressure is…

4

New Material Requirements Planning (MRP) Assessment for Dynamics AX 2012 R3

Get the most out of the Master Planning module by ensuring you have accurate and consistent data, the configuration settings you need, and the most important application updates. Identify MRP specific hotfixes required for Master Planning health. Identify possible MRP specific data problems that impact Master Planning performance and/or results. Identify and evaluate key MRP…


Embrace the extensions mindset with Dynamics 365 for Finance and Operations

A couple of weeks ago, we launched the last platform update 10 (August 2017) for Dynamics 365 for Finance and Operations, Enterprise Edition and, as in almost every release, there were changes regarding the Application Extensibility Plans. A lot of effort is being invested in the journey to a non-intrusive way to extend the application, and it…


Dynamics AX: Payroll Tax update 2017-R8 for the United States

Payroll Tax update 2017-R8 for the United States was just recently for the following versions of AX: Microsoft Dynamics 365 For Finance and Operations, Enterprise edition. Microsoft Dynamics AX 2012 US Payroll (R2 and R3) Microsoft Dynamics AX 2009 US Payroll Find the latest Payroll updates for each version below.   Microsoft Dynamics 365 for…


Setting up Direct Deposit Payments for US Payroll in Dynamics 365 for Finance and Operations

US Payroll in Microsoft Dynamics 365 for Finance and Operations gives you the option to pay workers by check or by electronic (Direct Deposit) payment. To set up the Direct Deposit NACHA feature for US Payroll, you need to make sure the following setups are complete. Payroll Bank account Payroll electronic payments – Method of…


What’s new or changed in Dynamics 365 for Finance and Operations, Enterprise Edition platform update 10 (August 2017)

A new platform version for Microsoft Dynamics 365 for Finance and Operations, Enterprise Edition has been released. To get more information about hotfixes included in this version (7.0.4641.16233 or August 2017 release), please view the KB article in Lifecycle Services (LCS). It’s interesting to note the new support for keyboard shortcut sequences in the browser client. The…


High Availability best practices for Dynamics AX 2012

In this blog post, I would like to summarize the best practices to ensure High Availability (HA) for Microsoft Dynamics AX 2012 R3. This has been a critical subject for many customers because Dynamics AX is a mission-critical business application meaning that any downtime impacting end users will result in financial loss. Business continuity doesn’t come for…


SQL Server 2016 CE and Dynamics AX 2012 R3

Hello, everyone!  As many of you are already aware, SQL Server’s Cardinality Estimator received its first update in SQL Server 2014 (this was its first update since SQL Server 7.0), then again in SQL Server 2016.  Many customers on Dynamics AX 2012 R3 who have upgraded to SQL Server 2016 and have changed the compatibility…


How AOS permissions to the TempDB are handled in Dynamics AX 2012

With Dynamiscs AX 2012, the concept of TempDB temporary tables was introduced to leverage the power of SQL Server. The TempDB database can store temporary tables as opposed to the traditional InMemory tables. But this technique might cause issues if the access to the TempDB database for the domain account running the AOS service is not correctly setup,…


How to change your Management Reporter Data Mart scheduling for Dynamics AX 2012

In this blog post, I would like to explain how you can view and edit the frequency of the Management Reporter Data Mart. The Data Mart is basically the data provider to integrate information from Dynamics AX operational database. During the installation of Management Reporter, new databases are created [ManagementReporter] and [ManagementReporterDM]. The frequencies of the…


IDMF and SQL Server 2016 Compatibility

Greetings, everyone! So there is likely some confusion as to whether or not IDMF is supported in SQL Server 2016.  Some time in August of 2016, a blog was published about this topic.  While this information held true at the time of its publication, there is new information surrounding this. In order for IDMF to…