Dynamics AX in the Field

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

Browse by Tags

Tagged Content List
  • Blog Post: Management Reporter 2012 CU10 for Dynamics AX 2012 is now available!

    Management Reporter 2012 CU10 (version 2.1.10001.112) 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; export to Excel enhancements, suppressing account category...
  • Blog Post: 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...
  • 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: 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...
  • Blog Post: 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...
  • 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: 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...
  • Blog Post: SQL Server Trace Flag 2371 for Dynamics AX

    In my travels around the country from one Dynamics AX customer to another the customer is usually aware of how important database Statistics are to the overall performance of Dynamics AX. The one thing I do not find though is Trace Flag 2371 enabled (or even know that it exists) or an in-depth understanding...
  • 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: 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: 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...
  • Blog Post: 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...
  • 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: 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...
  • Blog Post: 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...
  • 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: 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...
  • 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: 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 number...
  • Blog Post: SQL Server Trace Flags for Dynamics AX

    The purpose of this post is to list and briefly explain 4 SQL Server trace flags that we've found to be helpful in certain circumstances when working with our Dynamics AX customers in the field. In general, I don't recommend enabling these trace flags unless you're experiencing the specific issues they...
Page 1 of 1 (23 items)