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

Dynamics AX/SQL Maintenance Scripts

  Attached are the Maintenance Scripts I described in my EaaS Video “Microsoft Dynamics AX and SQL Server Maintenance Plans”   1.   SP_STATISTICS_MAINTENANCE 2.   SP_INDEX_MAINTENANCE_ENTERPRISE       a. Requires parameter values be set 3.   SP_INDEX_MAINTENANCE_STANDARD       a. Requires parameter values be set 4.   SP_DBCC_CHECK_DB       a. Requires parameter values be set       Database Maintenance Script.zip

12

DynamicsPerf needs your HELP !!

We REALLY, REALLY, REALLY want to hear from you !!! I need your help in defining a list of new features for DynamicsPerf.  Please leave comments below explaining what you would like to see and what impact that feature would have on the Dynamics community.    Here are a couple of items on my agenda…

14

DynamicsPerf Deep Dive Blog Series

  Welcome to my blog series on Performance Analyzer for Microsoft Dynamics (Dynamicsperf) !! In this series of blogs, I will be covering the technical details of the DynamicsPerf toolset and how to analyze the data. Bookmark this blog entry and check back often. I will be linking to all of the blogs in this…


Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Dynamics AX Installation

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. http://blogs.msdn.com/b/axinthefield/archive/2014/05/29/performance-analyzer-for-microsoft-dynamics-1-20-deployment-guide.aspx Performance Analyzer is delivered as a SQL Server solution file and includes a set of SQL jobs, X++ classes, VB scripts, and performance counters to initiate the collection process. It also includes a set of…

11

Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Core Installation

  INTRODUCTION DynamicsPerf (Performance Analyzer) ,http://dynamicsperf.codeplex.com,  is the tool used by Microsoft Dynamics support, Premier Field Engineers, and product team members to diagnose performance issues with Dynamics products. IMPORTANT: The purpose of the Performance Analyzer is to be used on a continual basis so it is important for administrators to understand the components that make…

4

DynamicsPerf Deep Dive – The Vision

  Before I dive into all of the things you can do with DynamicsPerf, I think it’s important that I describe its history as this will tell you a lot about the vision for the toolset. DynamicsPerf was born during the development of SQL Server 2005 which gave us Dynamic Management Views (DMVs).  Mark Prazak…

2

Time to patch SQL Server 2012 Service Pack 2

It’s time to patch SQL Server 2012 installations again.  There is one critical data corruption issue, a fix for Always On, SSIS bug that impacts DIXF and a new performance trace flag.   Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 1:   Data corruption bug rebuilding clustered indexes online…

5

How to manage Windows NLB when AOS Service stops

Consider the following scenario where there is an AOS Cluster configured for Services’ high availability by following the information published at “Configuring network load balancing for services AX2012” (http://technet.microsoft.com/en-us/library/hh397322.aspx) The NLB cluster is working fine and suddenly one of the AOS services stops. The rest of Windows Server components in that server are still up and running. The NLB…

1

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

If you have any question with regards to ERP versions supported by this release, please review the compatibility list here. Management Reporter 2012 CU10 (version 2.1.10001.112 & w/ Hotfix 2.1.10001.126 – see below) has been formally posted and ready for customers to download. This update release for MR 2012 contains enhancements around some of the most voted on suggestions in MSConnect including…


Convergence EMEA, November 2014

Hi all, We are pleased to announce that Premier Field Engineer team is going to be at next EMEA Convergence event. This will take place the 4-5-6 of November in Barcelona. You can now Schedule your private agenda with the Convergence Schedule Builder. Here are two sessions that me and my colleagues Steven Vlaanderen Oldenzeel…


DynamicsPerf 1.20 RTM is HERE !!

  I would like to announce that the RTM build of DynamicsPerf 1.20 has been posted to http://dynamicsperf.codeplex.com.  There is an upgrade script for both 1.20 RC0 and for those running on 1.16.  A big thank you to everyone that gave feedback on this version!! I will be authoring a series of blog articles called…

5

Patching Strategy for Dynamics AX

Innovation vs. Disruption One common challenge we are facing with large Dynamics AX implementation is the Patching Strategy. Our Premier Mission Critical customers have clearly reiterated the importance of delivering innovation without disrupting their critical business processes. Financial and logistics processes must run continuously, with limited window allowed for system maintenance such as applying application…


Top 10 issues raised from Infrastructure Design Review

The Microsoft Premier Field Engineer team helps customer to proactively secure their Dynamics AX 2012 deployment with the Infrastructure Design Review. This service focus on hardware and software requirements to meet business needs. The assessment can help customer to secure the implementation phase for new installation, but also to anticipate increase of workload and user…


Using Performance Analyzer for Microsoft Dynamics in a Development, Test, or QA environment

  USING THIS PROCESS WILL KEEP SOME PERFORMANCE ISSUES OUT OF PRODUCTION !!! BE PROACTIVE NOT REACTIVE WITH YOUR DYNAMICS PERFORMANCE !!   Using Performance Analyzer for Microsoft Dynamics in your production environment I think is pretty well understood the benefits of doing that activity.  All of us are constantly trying to tune our production…

2

Commenting in Performance Analyzer for Microsoft Dynamics (DynamicsPerf)

  A little, mostly unknown feature in Performance Analyzer for Microsoft Dynamics, http://dynamicsperf.codeplex.com,   is the ability to add comments to the database.  We have significantly upgraded this functionality in version 1.20 of the toolset.  The intent of this functionality is twofold.  The first being that this is a way to keep track of tasks that…


BASELINES with Performance Analyzer for Microsoft Dynamics (DynamicsPerf) are here !!

  Performance Analyzer for Microsoft Dynamics (DynamicsPerf) is built to help resolve performance issues with Microsoft Dynamics products. As currently released it does a very good job at finding the following issues: SQL Configuration Database Schema (indexes) Application Code (limited) Application Configuration Poorly executing SQL statements Given all of this, there were still questions that…

2

New home for DYNAMICSPERF !!

I would like to announce the new home for Performance Analyzer for Microsoft Dynamics.    http://dynamicsperf.codeplex.com   I have posted our current stable build of version 1.20 to this location.  Please download and use this newer version.  I will have some additional blog posts on this version soon.   Rod “Hotrod” Hansen  


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

Management Reporter 2012 CU9 has been posted for download! This release contains enhancements to the Management Reporter Web Viewer around opening and refreshing reports along with additional troubleshooting information in the Configuration Console related to data issues in Dynamics AX. Here’s a summary of the new Management Reporter 2012 CU9 features: View a list of…


Dynamics AX and SQL Server Trace Flags, Quick and Dirty

  I searched through this BLOG to find any articles that list and explain all the SQL Server Trace Flags that we Field Engineers may have used or recommended for Dynamics AX.  I found a few recommending and explaining 1 or 2 or the generic Best Practice Trace Flags but no summaries of all of them that we as field…

2

Setting Dynamics AX 2012 R3 Demo with LCS and Azure

Hey all you Dynatics (Dynamics Fanatics) out there! With the announcement today I thought I’d drop a quick start guide for setting up the Dynamics AX 2012 R3 Demo Virtual Machine (VM) on Azure to save you a few minutes. The full guide is here: http://technet.microsoft.com/en-us/library/dn741578.aspx Prerequisites and warnings now: This Demo setup uses Lifecycle…


Management Reporter 2012 CU8 for Dynamics AX 2012 is now available

Microsoft’s vision for Management Reporter (MR) continues to mature as a powerful Corporate Performance Management (CPM) solution with greater stability and rich functionality enhancements for Dynamics AX 2012 . This new CU release is a testament that the Product Group for MR is listening and remains sensitive to our customer’s domestic and international Financial Statement (real-time) reporting needs/requirements by…


Reduce, Reuse, and Recycle. How to use SQL Server Compression to save (reclaim) drive space in Non-Production Dynamics AX environments.

  NOTE: Compression is only available in SQL Server Enterprise Edition and Higher and also Developer Edition.   Many Dynamics AX Customers have multiple non-production environments used for TEST, DEV, STAGING, UAT, or etc…  For each one of those non-production environments there is usually a full copy of the Dynamics AX Production database and if that database…


Financial Reporting by Site – Dynamics AX 2012

  I recently had a partner/customer that came to me with a few things they needed to accomplish in AX 2012 when it came to reporting.  They were running an earlier version of AX 2012 very close to RTM and were trying to make an upgrade decision.  They were going to soon be opening another…


TempDB Errors in AOS event log after SQL Server Cluster Failover or AlwaysOn Availability Groups Failover (Update 8/27/2014)

  If you have ever seen errors in your AOS Event Viewer Logs after a SQL Server Cluster or AlwaysOn Availability Groups Failover and wondered why it is happening here is a brief explanation.   Object Server 01: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop the table ‘tempdb.DBO.t855_489F061A83074B41907007FFAE3B5D41’, because it does not exist or you…

5

Efficient Dynamics AX Application Lifecycle Management approaches with Team Foundation Server in the cloud

Premier Field Engineering is delivering many Code Review for Dynamics AX all over the planet. One thing we often face is the fact that a real Application Lifecycle Management (ALM) approach is not in place. Real application lifecycle management and even a proper version control with Team Foundation Server (TFS) is still a mystery for…

3

What time is it? Another new feature in Performance Analyzer for Microsoft Dynamics ( DynamicsPerf )

In the next release of Performance Analyzer for Microsoft Dynamics (DynamicsPerf), we will be making a schema change to the AX_SQLTRACE table.  Currently, the [CREATED_DATETIME] column is stored in GMT time.  Dynamics AX stores it this way to adjust for clients being in multiple time zones. So, in our next release, we will be adjusting…


Drip, Drip, Drip time to patch SQL 2012 SP1

For those Dynamics customers on SQL Server 2012 Service Pack 1 or above, Cumulative Update 7 is released http://support.microsoft.com/kb/2894115.   There are 2 memory leaks that have been patched that impact Dynamics AX:   http://support.microsoft.com/kb/2881661 http://support.microsoft.com/kb/2895494   Dynamics AX uses these features.  I’ve personally seen this at customers with AX 2009 and AX2012.  You can…

5

Top 10 issues discovered from Dynamics AX Code Review

Three years ago, the Premier Field Engineer team started the delivery of the Dynamics AX Code Review for Premier customers. It has been quite an interesting journey seeing many customization from different instances. Today I would like to step back and reflect on some of the most common issues.If you are a senior developer on…

8