Convergence 2011 – Coming Very Soon

We’re less than four weeks away from Convergence 2011 – it is coming up quick.  Convergence 2011 will be held in Atlanta this year at the Atlanta Convention Center from Sun, April 10- Wed, April 13.  Dynamics AX will be featured in well over 70 sessions covering topics across AX 2009 and the forthcoming AX 2012…


Capture Database Blocking with 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 capturing blocking information with this toolset on your SQL Server environment.  This tool will capture blocking information for any SQL…

9

Dynamics AX Event IDs

Recently a fellow PFE compiled a list of the AX Event IDs with their description and a possible action. This post is intended to give end users a better idea of the messages generated by the AOS service within the Application Event Log within the Windows Event Viewer. If you are receiving messages, it may…


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

Inventory Costing in AX 2009

I wanted to explore some scenarios that illustrate a few important concepts related to inventory costing– look at differences between physical and financial inventory, and how this affects inventory values. Please reply to the post if you have questions or comments, or if you are interested in additional posts on this topic. This is not intended…

13

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

Podcast – Performance Analyzer for Dynamics AX

We did another podcast today to provide some more background on the Performance Analyzer for Microsoft Dynamics.  Rod Hansen joined me to discuss the key benefits and uses of the toolset.  He answered questions on who should use it, what are his go-to scripts inside the tool,  and what AX specific functionality exists.  Click the…


Dynamics AX Tracing (Part 1)

Dynamics AX has a tracing feature that allows you to generate ETW traces of the client and server activity on your system. The information collected in these traces includes a call tree, SQL statements, and durations for all of the different code that executes. This kind of trace data can be extremely useful when troubleshooting…

18

Performance Analyzer for Dynamics

Our Dynamics Services team has been doing Performance services for customers over the past 10 years.  We’ve learned a lot in that time – what information to collect, what key pieces of data to focus on and how to analyze all this data.   Over the evolution of SQL Server and our products, we’ve used a…

8