Capacity Planning for Dynamics AX

Since Microsoft Dynamics AX 2012 was launched in 2011, hundreds of Premier customers engaged Premier Field Engineering team to provide guidance on new Dynamics AX 2012 infrastructure, especially when upgrade was executed from legacy versions such as Dynamics AX 2009. Today, most of our customers are live and look for optimization of their existing infrastructure, they need to better justify cost associated with IT capacity and they…


DynamicsPerf 2.0 Setting Up Security for Remote Collection

One of the new things to be done with DynamicsPerf 2.0 is setting up security for both local installs and especially remote installs using Linked Server.  In this blog, I will be covering the security setup that you will need to have for each type of installation. LOCAL A local install assumes that the DynamicsPerf…

1

DynamicsPerf 2.0 is HERE !!

Performance Analyzer for Microsoft Dynamics 2.0 has been posted DynamicsPerf 2.0 RTM.    I would like to thank the entire Dynamics community and SQL DBAs that have helped during the process of building this new and exciting version of Performance Analyzer.  Everyone in the community has done a great job of contributing to this version…

5

What’s New in DynamicsPerf 2.0 !!

  What?  There is a DynamicsPerf 2.0?  It’s taken 6 months and almost 600 hours of coding time.  This upgrade really is worthy of the 2.0 version. What has changed?  EVERYTHING !!  Don’t worry it still has the same look and feel. So, with that, let me begin to go through the new features.  …

6

Public Readiness for Dynamics 365 Finance and Operations, Enterprise Edition

Hi all, Please find below all public information related to Dynamics 365 for Finance and Operations.  [last update 19/01/2018] Product information Roadmap and Update Policy Service Level Agreement Dynamics 365 Documentations and public Wiki site Product availability white paper, Localization portal and Localization per countries Trust Center for Dynamics 365: compliance, security, Privacy and transparency. Experience Dynamics…


How to solve AX Data Refresh with Powershell?

The number of resources regarding PowerShell with AX, at our disposal, is so small and it is so little we can do with them, this is a topic that I would like to increase awareness starting an open discussion. I will try to bring to the blog scripts that have been helping me to optimize…


SQL Server Data Compression for Dynamics AX Part 4 – Actions post compression

In part 1 of the series we discussed Costs and Benefits of data compression together with some Best Practices to successfully compress your database. In part 2, we discussed the planning for Data Compression including prerequisites validation and steps to identify the best candidates for compression. In part 3, we showed you two different approaches…


SQL Server Data Compression for Dynamics AX Part 3 – How to compress Dynamics AX databases via SQL Server or Dynamics AX

In part 1 of the series we discussed Costs and Benefits of data compression together with some Best Practices to successfuly compress your database. In part 2, we discussed the planning for Data Compression including prerequsites validation and steps to identify the best candidates for compression. In this post we will show you two different…


SQL Server Data Compression for Dynamics AX Part 2 – Planning Database Compression

In part 1 of the series we discussed Costs and Benefits of data compression together with some Best Practices to successfully compress your database. In this post we will walk you through the planning of Data Compression, including Pre-requisites Validation and 3 steps to identify the best candidates for compression: 1. Estimate the space saving…


SQL Server Data Compression for Dynamics AX Part 1 – Introduction and Best Practices

In this blog post we will discuss the Benefits and Costs of database compression and we will provide Best Practices for successful data compression. Why data compression matters? Data compression is one of the Data Volume Management strategy (together with Data Clean up and Data Archive) which as we know, consists on actively managing the amount and type…


SQL Server Data Compression for Dynamics AX Blog series

Welcome to our blog series on SQL Server Data Compression for Dynamics AX. In this series of blogs, we will describe the steps to successfully plan and compress your Dynamics AX production databases. We will also provide some best practices for compression. This blog series was written by Dynamics AX and SQL Server Premier Field Engineers who…


How to analyze live performance issues with Dynamics 365 Finance and Operations, Enterprise Edition

Back in July, I posted a step by step flow to troubleshoot performance issues on Dynamics AX 2012.  Today I would like to share the same list but this time for the latest release of Dynamics AX available on Microsoft Azure through Lifecycle Services. Because the new Dynamics AX is running as a Cloud Service managed by Microsoft, it means…

2

Interacting with IL-generated TempDB data

Together with Microsoft Dynamics AX 2012, there was a new execution mode introduced; called as “IL” execution mode, which is in some references also referred as “CIL” execution mode. The “IL” stands for “.Net Intermediate Language” and referring to the Intermediate Language available in the .Net Technology, see also X++ Compiled to .NET CIL and…


Collection Classes – Iteration performance

Collection Classes are very popular and frequently used composite data types within the Microsoft Dynamics AX developers’ community. The idea is to have generic collections, which provide you the ability to create and maintain in-memory collections of any type of objects at run-time. In many business scenarios, there is a need to iterate through the…


We Are Hiring!

Are you a motivated individual who enjoys working in a team-oriented environment? Are you passionate about working with customers and solving complex situations? Do you enjoy the thought of providing proactive services to customers to improve the overall health of their Dynamics AX implementations? If so, the Premier Field Engineering team is looking for you…

1

DynamicsPerf 2.0 Release Candidate 0 is HERE !!

Release Candidate 0 is finally complete.  You can find the download here: DynamicsPerf 2.0. A big THANK YOU to my early testers of RC0!! They were able to help me find a last minute issue which was the cause of the delay between when I posted the What’s New in DynamicsPerf 2.0 Release Candidate 0…

4

What’s New in DynamicsPerf 2.0 Release Candidate 0

First, I want to say “Thank You” to the community.  All of the feedback has been greatly appreciated.   Let’s start with SSRS data collection.   This is now working as designed.  There were some schema changes needed to get this working as necessary so the upgrade script will truncate the SSRS_HISTORY table and the…

11

Dynamics AX 2012 Performance Troubleshooting step by step

Dynamics AX Performance Troubleshooting Step by Step In this blog post, I would like to summarize the different tools that one Dynamics AX administrator can leverage to troubleshoot performance issues. The typical situation is when end users are complaining of slow performance when using the Dynamics AX application and you are being asked to investigate…


Moving Customizations Between Layers in Dynamics AX 2012

Recently, one of our clients wanted to consolidate their customizations distributed between two different layers (CUS & USR) into one layer (CUS). Ideally, all customizations developed by customers should reside in the CUS layer to facilitate maintenance and easy upgrades. Hence, they decided to move the customizations in USR layer to the CUS layer, in…


Resetting the Management Reporter 2012 data mart (with CU15+ via Powershell)

The release of Management Reporter 2012 CU15 has delivered a new way to reset (rebuild) the Management Reporter 2012 data mart using Powershell.   Please refer to the steps below as a guideline on how to leverage this new data mart reset process: 1. Before starting, make a backup of the ManagementReporter and data mart…


Performance issue in VMWare 6

We recently ran into a performance issue with a Dynamics customer that was running VMWare 6.  The issue is caused by incorrect support in the VMWare network drivers for a new feature in Windows Server 2012 R2.  You can read more about this issue here: https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2129176 There is a workaround for customers who don’t have…


Management Reporter 2012 (AX 2012) vs Financial Reporting (Dynamics 365 for Operations) FAQ

Recently we had the privilege of sitting down with one of our partners to discuss the new Financial Reporting functionality in Dynamics 365 for Operations (aka Management Reporter for AX 2012). Although the name has changed in Dynamics 365 for Operations, the core of its purpose and functionality remains intact.  However, during our review, questions did surface pertaining…

13

Management Reporter 2012 CU15 (+Hotfixes 1-4) now available!

Management Reporter 2012 CU15 RTM (version 2.12.15001.56) and CU15 Hotfixes (1-4) have been formally released and ready for customers to download.   CU15 contains the following functional enhancements: Improved responsiveness in the Web Viewer A Search bar enhancement is now part of the Web Viewer giving you the ability to search through the current level of the report…


Setting up database log for global address book

One of the useful frameworks within the Microsoft Dynamics AX 2012 to implement the Auditing and Compliance requirements is the Database log framework. While the functionality is easy to setup and use from the following entries in the application: /System administration/Setup/Database/Database log setup /System administration/Inquiries/Database/Database log /System administration/Reports/Database/Database log We would like to clarify the…

1

Microsoft Dynamics AX 2009/2012 – SQL Server 2008 R2/2012/2014 Configuration Check List for “Go-Live”

Microsoft Dynamics AX 2009/2012 – SQL Server 2008 R2/2012/2014 Configuration Check List for “Go-Live” Server Level Settings Max Degree of Parallelism Best Practice is that the Max Degree of Parallelism on the production Dynamics AX SQL Server be set 1 Parallelism – When SQL is sent a SQL statement it runs it through the optimizer…

2

What’s New in Beta 5

A big THANKS to the community that has been helping test DynamicsPerf 2.0 !! Beta 5 has been posted here: DynamicsPerf 2.0 Beta 5 For anyone who has an older beta installed, it is highly recommended to upgrade to Beta 5.  The biggest issue that has been corrected in Beta 5 is the purge script. …

13

AOT Find tool – old but useful

I was looking for a certain pattern in the code, using the AOT Find-tool. There is an option to use “Filter”, which will then run a validation function like : boolean filterMethod(str _treeNodeName, str _treeNodeSource, XRefPath _path, ClassRunMode _runMode) { %1 } where the %1 will be replaced with your filter text to form a…

2

DynamicsPerf 2.0 QUERY ALERTS

In the upcoming Beta 3 of DynamicsPerf 2.0, we have implemented a new feature called QUERY ALERTS.  The inspiration for the design has come from all of you.  One of the big challenges that we all face with performance is that sudden slowdown of the system.  In general, this happens for 2 major reasons, database…

1

DynamicsPerf 2.0 Comparing AX schema

With DynamicsPerf 2.0 , we made schema changes to better support multiple databases and environments.  This change includes AOTEXPORT class that provides table and index schema from Dynamics AX into the DynamicsPerf database. The new AOTEXPORT class now writes data directly to DynamicsPerf.  What this allows you to do that you really couldn’t do before…


DynamicsPerf 2.0 Feedback

We would love to hear from everyone that installs DynamicsPerf 2.0.  Please leave your feedback in the comments of this post.  Please add the following: Dynamics Product/Version SQL Version How has DynamicsPerf helped you? What would you like to see added next? Please post any defects on the ISSUES page of the DynamicsPerf on Codeplex…

22

DynamicsPerf 2.0 IS HERE !!

I have opened the downloads for DynamicsPerf 2.0 Beta 1 today Jan. 6, 2016.  You can download it from here: DynamicsPerf 2.0 for SQL2008R2 and Above. The deployment guide for installation can be found here: DynamicsPerf 2.0 Deployment Guide.aspx Please post any issues you may find on the ISSUES tab of the download site.  I…

7

Setting up Windows Performance Monitor Templates

To log valuable information about your database server such as disk, processor, memory and network, it is important to configure and schedule the performance counter logging. In the following steps, you will configure the database server for performance counter logging. This information will be logged to performance counter log files. First we can setup the…


DynamicsPerf 2.0 Historical Tables and Baselines

Another one of the new features in version 2.0 is the addition of HISTORICAL TABLES: QUERY_HISTORY INDEX_HISTORY We collect query data every 5 minutes by default and index data every hour on the hour. With this increase in collection of detailed data, it was pretty apparent that the DynamicsPerf database would quickly grow to large.We…


DynamicsPerf 2.0 Scheduling Engine

  One of the new features of DynamicsPerf 2.0 is the way tasks are now run using a scheduling engine inside of DynamicsPerf. There were 2 goals for this new design.  The first being able to deliver customized data collection for different environments.  A good example of this would be for collection at a retail…

6

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