Intro to Managing an AX Consulting Practice

My name is Eric Newell and I manage the Premier Field Engineering team for Microsoft Dynamics AX.  We’ve been bringing you many great technical articles over the past year, and I wanted to broaden the scope of the blog site a little by highlighting some key non-technical concepts that are important to a successful ERP…

2

Logon Dialog Box when Launching a Reporting Services Report from AX.

I was recently working with a Dynamics AX 2009 customer who had Enterprise Portal and SQL Server 2008 R2 Reporting Services installed on the same server – a fairly common configuration. Everything worked great except that they were encountering a barrage of logon dialog boxes each time they launched a Reporting Services report from the…

2

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

Convergence Replay – Database Compression and Encryption

Thanks to the big crowd who attended Michael DeVoe’s Convergence Session on Tuesday on Leveraging Microsoft SQL Server Data Compression & Transparent Data Encryption with Microsoft Dynamics Products.  Yes, the title barely fit on the opening slide :).  The audience asked some great questions and Michael packed a ton of information into 70 minutes of time…

2

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

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

How to Monitor for Long Running Queries in AX

Does Dynamics AX have any built-in functionality for monitoring system performance? This is a question I frequently get asked, so I thought I would address it here with a quick explanation of one of the tools that AX has had for a long time but very few people know about and use. I call it…

2

Video: How to collect a trace within Dynamics AX

When trying to diagnose performance issues in Dynamics AX, two of the key tools that we use are the Performance Analyzer (for SQL activity), and the Event Trace Parser for Microsoft Dynamics® AX (aka Trace Parser).  Trace Parser is a user interface and data analyzer built on top of the Event Tracing for Windows (ETW)…

2

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

Financial Consolidations – Dynamics Ax 2009 (Part 2)

Please find the Part1 here. III) Perform a Consolidation: Options to perform consolidation: From the same database using the online option From and, or to another database using the Import/Export option Before you perform a consolidation at the close of a period, ensure that the period closing preparatory activities are performed, but do not close…


Financial Consolidations – Dynamics Ax 2009 (Part 1)

Financial Consolidations process: 3 steps to perform consolidation in Microsoft Dynamics Ax 2009.           I )  Consolidation company setup           II)  Subsidiary company setup           III) Perform consolidation I) Consolidation company setup: Consolidation company creation:  Consolidation designated company will not be available for any operational process except having consolidation entries posted in here. Path: Dynamics Ax > Administration…


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

New DMVs in SQL Server 2008 R2 SP1 and SQL 2012 (‘Denali’) and Performance Analyzer for Microsoft Dynamics

One of the new features in Performance Analyzer 1.10 for Microsoft Dynamics is support for new DMVs in SQL 2008 R2 SP1 and SQL 2012. In this blog, we’ll explain what the new DMVs are and how they are used in analysis of performance issues in Microsoft Dynamics deployments.   New DMVs: sys.dm_os_windows_info                 This…

2

Interviewing AX Candidates – What I Look For (Part 1)

As I mentioned in the post about tamping someone up on AX, I look for candidates who have expertise in AX Performance, AX Application (at least one particular module) or AX development.  Because of this, we have to bring in the right people on the team and ask the right questions to determine if our…

2

Are your AX 2012 AOS servers load balancing?

If you’re familiar with how AX 2009 load balancing works, you might get caught off guard when you find out that standard AX 2012 AOS clustering only load balances some of the communication to your AOS servers. The rest may only be going to a single server without you knowing about it. If that’s the…

2

Database Mirroring with Dynamics AX

Is the AOS a “mirror aware” service? If so, what’s the user experience when a failover happens? These are two of the questions I recently received from a customer as they were planning their database high availability solution.  When it comes to database high availability for Dynamics AX, a SQL cluster is by far the most…

2

Degraded Performance on Dynamics AX and the SQL Server TokenAndPermUserStore

[Ed. Note – this is a repost of an article Michael DeVoe posted to the NAV Team blog, but it applies equally to Dynamics AX] I recently came across an issue with a large Dynamics ERP customer where queries were becoming slower over time, and blocking significantly increased.  After going through the normal troubleshooting activities,…

2

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


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

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

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

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

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

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

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…


Managing Client Versions

How do you know if you have updated all of your client machines to the correct and current AX version? For a lot of companies that have distributed clients, managing the client software can be somewhat of a headache for the IT staff.  As the roll out of new kernel builds are released, it is…


AXUG Roundup – January in Minneapolis

Rod Hansen and I headed south to Minneapolis (yes, everything is south of Fargo) to join the Minnesota chapter of AXUG for dinner and a discussion on the Performance Analyzer tool.  The Minnesota chapter is very well attended and we had a good turnout for this meeting – about 20 folks there in total.  Ben Syltie…

1

SQL Server Lock Escalation and Blocking

Back in November 2010 I talked about four SQL Server trace flags that I found to be helpful in improving performance for Dynamics AX.  http://blogs.msdn.com/b/axinthefield/archive/2010/11/04/sql-server-trace-flags-for-dynamics-ax.aspx. One of the trace flags I mentioned was 1224. This is the one that changes the default behavior for lock escalation. Since lock escalation is just one of many reasons you…

1

Keeping Your Services Team in Touch

A.K.A. Scrum Meetings for Services Groups Since it’s a Friday and my team’s Scrum meeting is coming up in a few minutes I thought this would be a good time to talk about how we do Scrum meetings in Services … As I’ve mentioned in earlier articles, we require a team approach to deliver on any of…

1

Microsoft Dynamics AX 2012

This summer, there was all of this hype about Microsoft’s Dynamics AX 2012 Benchmark. As an intern I was wondering, “Who cares?” To me it was just a name. However, after some questioning I found out interesting details. I was able to dig deep and ask who cares, why, and what the future might expect…

1

Podcast: Leveraging SQL Compression with Microsoft Dynamics Products

We are podcast crazy this week on the Premier Field Engineering for Dynamics team.  The PFE team will have a podcast a day going this week to get everyone jazzed up for Convergence next week.   Our Dynamics AX focused podcast centers around using the compression capability available in Microsoft SQL Server 2008 Enterprise Edition.  With compression you can…

1

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

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…


Bio – Siva Jammalamadaka

Siva is a Premier filed Engineer in Microsoft Services focused on the Dynamics AX product.  He has been working on the Dynamics AX product for over 6 years.  Originally started as a tester for a partner as a functional analyst for Finance.  Worked in various capacities Sustained engineering, testing, functional analysis and most recently worked…


Choosing a Single Deployment or Multiple Deployments of AX2009

Multiple AX 2009 Deployments versus a Single Deployment Dynamics AX2009 has the capability to run a single deployment supporting multiple companies within the same database. There are some considerations when deciding whether to have a single deployment of AX2009 or multiple deployments for each of your companies. These considerations, along with the features AX2009 utilizes…

1

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


What is AX in the Field?

We are starting a new blog on the topic of Dynamics AX to provide updates from the field-facing teams on what’s going on with AX.  Michael Posl kicked off the content this week with his post on managing users between environment and you’ll see contributions here going forward from different service teams in Microsoft including…

1

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