Dynamics AX in the Field

Microsoft Dynamics AX from the Premier Field Engineering team at Microsoft.

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: How your history can help you improve your future? Come to Convergence 2014 for the answer !!

    HINT: It’s an 8 letter word. I will be presenting Supercharging performance with Performance Analyzer for Microsoft Dynamics at: Wednesday March 5 3:30pm – 4:30PM Thursday March 6 2:00pm – 3:00pm I will explain the following new feature coming in the next release of...
  • Blog Post: 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...
  • Blog Post: SQL Server Parameter Sniffing with Dynamics AX, just plain evil. (Redux 5-19-2014)

    I do not want to write a novel or a technical manual on Dynamics AX and SQL Server Parameter Sniffing and the problems it causes so I try and keep this as short as possible. When Dynamics AX X++ code in converted in TSQL cursors it is usually in the form of a SQL Statement usually with a WHERE clause...
  • Blog Post: Top 10 issues discovered from Dynamics AX Health Check

    The Premier Field Engineer team has been running several hundred of Dynamics AX Health Check worldwide and I thought it would be interested to share the most common issues discovered during onsite. Some of the following issues might look trivial but the reality is that despite all the literature that...
  • Blog Post: 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...
  • Blog Post: Performance Analyzer Reports

    We're excited to introduce the next evolution with our Performance Analyzer for Microsoft Dynamics toolset. We'll review the concepts today at Convergence at the Performance Analyzer for Microsoft Dynamics session at 5pm in the Hilton Ballroom B on the 2nd floor. In this post, we'll list the reports...
  • Blog Post: 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....
  • Blog Post: Update on determining Disk Latencies with Performance Analyzer for Microsoft Dynamics

    In my previous blog about Determining Disk Latency with Performance Analyzer for Microsoft Dynamics , I spoke of how to determine the disk latency. In testing, we have determined that the computed latency from sys.dm_virtual_io_file_stats does not match Windows Performance Monitor Avg. Disk Sec/Read...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Top 5 Cases for Remote Service Delivery

    Our Premier Field Engineers travel a lot. When customers need assistance during deployments or need a workshop or want to make sure their team is up to speed on what we're delivering, they request us to be onsite and we come on out. The opportunity to be out working directly at the customer site greatly...
  • Blog Post: Performance Analyzer for Dynamics - Feedback Requested

    We are getting close to the release of the Version 1.10 for the Performance Analyzer for Dynamics , and we thought it would be a great time to start getting feedback for the next version of the tool (Version 1.2). We have some plans in place already, including adding hooks into AX 2012 to pull more configuration...
  • Blog Post: 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...
  • Blog Post: Convergence Replay - Performance Analyzer for Microsoft Dynamics

    Thanks to everyone who attended Rod Hansen's session on the Performance Analyzer for Microsoft Dynamics at Convergence. We had a great turnout and great interaction within the session. They are still compiling the survey results, but as of last night, Rod's session was the #1 rated session with more...
  • Blog Post: Optimizing AX Batch Performance - Batch Group 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...
  • Blog Post: Dynamics AX Tracing (Part 2)

    In part 1 of this series, we covered the basic prerequisites of taking a trace. In this post I'm going to cover some best practices around capturing trace data and how to troubleshoot some common issues that may prevent trace files from being created. The steps below apply to both Dynamics AX 2009 and...
  • Blog Post: 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...
  • Blog Post: 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. ...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 2 (27 items) 12