Database Maintenance Strategies for Dynamics AX

Database Maintenance Strategies with Microsoft Dynamics AX AX utilizes SQL Indexes in order to speed up queries to the database. It is important that any index created is analyzed for its usage pattern; for example, will the query only be made once per day, or thousands of times in a loop? It might not be…

5

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

Interviewing AX Candidates – Questions (Part 2)

Please read part 1 first to see what we’re looking for in candidates.   Here’s a list of some questions that I ask candidates who are interested in Question Intent Tell me a little about yourself Get a background on the candidate – always interesting to see where this simple question takes them – I’ve had…

5

Performance Analyzer 1.16 for Microsoft Dynamics IS HERE !!

You can download the latest release of Performance Analyzer 1.16 for Microsoft Dynamics at the following:  http://dynamicsperf.codeplex.com.   This release officially supports SQL Server 2012 and all currently released Dynamics Products.  There have been several performance improvements incorporated into this version especially around analyzing QUERY data.  For the operational staff, we have enhanced the QUICK…

5

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

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

Dynamics AX 2012 Cumulative Update 7 (CU7) is now released!

In case you missed it, I’m happy to relay we recently released Dynamics AX 2012 R2 Cumulative Update 7! CU7 includes enhancements to several modules or feature areas, including the highly anticipated Data import, export, migration improvements, and integration with Lifecycle services. AX 2012 R2 CU7 is posted as KB number 2885603, build number 6.2.1000.4051….

5

Ramping Someone Up on Dynamics AX

What does it take to learn Dynamics AX?  It’s not for the faint of heart – the product takes years to master and there’s still no one I’ve met who knows every inch of it backward and forward.  First, you have to start by finding the right candidate, so you have to know what you’re…

4

What is my data distribution by company(PARTITON and or DATAAREAID) for a specific Dynamics AX table?

  If you have ever asked yourself the question “What is my data distribution by company(PARTITION an or DATAAREAID) for a specific Dynamics AX table?”, wonder no longer.  Attached is a TSQL Stored Procedure you can add to your Dynamics AX database (4.0, 2009, 2012, 2012 R2…) and then run it against any table in…

4

Dynamics AX Trace Parser (Part 4)

Ok, I guess this three part series just got extended to four. I just have a few last things on the AX 4.0 / 2009 Trace Parser tool that you might find useful. Soon we’ll all be using the AX 2012 version right? Anyway, here it goes… Most of the time Trace Parser works the way it should,…

4

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

Performance Analyzer 1.10 for Microsoft Dynamics

We would like to announce the release of Performance Analyzer 1.10 for Microsoft Dynamics.  This new and exciting release has a long list of new features: Peformance Analyzer 1.10  NOTE: SQL Server 2008 and above only for this version. ·         An hourly capture of data that shows your transaction volume per table per hour ·        …

4

Lean Manufacturing in Dynamics AX 2012

I recently spent some time digging into Lean Manufacturing in AX 2012, so I thought I’d post a few notes and some information about lean concepts in AX 2012. Overall, I think it looks great and appears to work well in mixed mode. You can use lean kanbans and production orders even within the same…

4

Setting up Performance Analyzer for Microsoft Dynamics

Performance Analyzer 1.0 for Microsoft Dynamics is the tool used by Microsoft Dynamics support, Premier Field Engineers, and product team members to diagnose performance issues with Dynamics products.  The following is a step-by-step guide to installing this toolset on your SQL Server environment. This tool is delivered as a SQL Server solution file and can…

4

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…


Standard Cost in AX 2009

Using the standard cost model in AX 2009, all receipts and issues are valued at the active cost. Costs are maintained in the item price form, which is available using the Price button from the item form.  A few things to note when looking at the new price/cost form: 1.       Price type – 3 price types…

4

Recording manual check in Dynamics AX

Recording manual check in Dynamics Ax 2009 Step 1: Setup bank management parameter Path: Dynamics Ax > Bank > Setup > Parameters Set field ‘Allow checks for bank or ledger accounts’ = True Note: This configuration enables manual check recording capabilities for CEU company in the system. Step 2: Create bank transaction type ‘Check -…


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

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

AOS Load Balancing

I’ve been questioned several times recently about AOS load balancing in Dynamics AX, and there seems to be quite a bit of confusion about how to properly configure AX for AOS load balancing, as well as high availability. Here are a few clarifications that apply to Dynamics AX version 4.0, AX 2009 and AX 2012:…

3

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…


Currency Round-off and Maximum Penny Difference

Knowledge Base article 923022 explains when the penny difference account is used in Dynamics AX. I was recently asked how this works in connection with the maximum penny difference setting in GL Parameters. In this post, I have used the example provided in the mentioned article to illustrate how the two settings work together. When…

3

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

Comparing AX and Active Directory User Accounts

I was recently working with an AX 2009 customer who wanted to compare the user accounts configured in AX with the user accounts in Active Directory. The basic goals were: Find all AX user accounts that no longer exist in Active Directory. Find all accounts that are disabled in Active Directory but not in AX….

3

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…


Optimizing AX Batch Performance – Batch Thread Configuration

Are you pushing a lot of transactions through the AX batch framework?  Are you wondering if you’ve optimized the system for your workload?  We recently did some testing in our lab to illustrate some of the performance and concurrency characteristics of the AX 2009 batch framework. Our goal was to show the impact of two…

3

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

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…


How Preallocated Number Sequences are Cached in AX

Number sequences handle automatic allocation of voucher numbers, invoice numbers, and journal numbers used by Microsoft Dynamics AX. You can set the allocation to be Continuous, or Preallocate a block of numbers. When using Continuous, gaps are not allowed, so a trip to the database is needed to get the next number.    When preallocating, a block…

3

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

Update multiple records with ‘Fill Utility’

Fill Utility: The Fill utility enables authorized users and/or administrators to mass-update records, similar to the find and replace functionality. This utility assists administrators or users during implementations or when business process changes affect multiple records. Caution:   1) It is recommended practice to take backup of entire database before performing this ‘Fill Utility’ operation.                  2)…


Dynamics AX, Index Fragmentation, and You.

I have been onsite at a lot of Customers who believe that Index Fragmentation is major influence on overall Performance for Dynamics AX.  I actually have a hard time convincing them that its impact is relatively low on overall performance.  They also raise the issue that they can no longer fit their re-index job into…

3

Podcast: Dynamics AX Shop Floor Control

We conducted our latest podcast today on Dynamics AX Shop Floor Control. This week’s topic covers the basics of Shop Floor and featured Cody Marshall from our Premier Field Engineering team. Cody discussed the background of Shop Floor Control, licenses requirements, functionality of payroll, and even more. Here’s the link to listen to the podcast: http://www.blogtalkradio.com/pfedynamics/2011/06/14/shop-floor-control-in-dynamics-ax…

3

AX 2009 and Report Builder 3.0

Have you installed one of the new Report Builders– version 2 or version 3– and can’t get AX to launch it?  This posting addresses the issue and walks you through the steps to point AX to the new version. The first step is that you will need to get Report Builder 2.0 or 3.0 installed…


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

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

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

Dynamics AX and little Orphaned SPID Annie

  One of the top questions I am asked by customers when I am on site is what causes AX Orphaned SPIDS and what to do with them and how to identify them.  As we know Orphaned SPIDS can cause blocking which lead to end user frustration.  They are usually caused by users not exiting…

2