Dynamics AX in the Field

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

Browse by Tags

Tagged Content List
  • Blog Post: Dynamics AX/SQL Maintenance Scripts

    Attached are the Maintenance Scripts I described in my EaaS Video "Microsoft Dynamics AX and SQL Server Maintenance Plans" 1. SP_STATISTICS_MAINTENANCE 2. SP_INDEX_MAINTENANCE_ENTERPRISE a. Requires parameter values be set 3. SP_INDEX_MAINTENANCE_STANDARD a. Requires parameter values...
  • 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 – What’s the impact of running DynamicsPerf on my system?

    This is a question that I get asked a lot, and it’s a very natural one to ask. The short answer to this is almost nothing. We are simply collecting DMV data that SQL Sever already has in memory and inserting that into our DynamicsPerf database. For Dynamics AX customers, we are collecting some...
  • 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: Management Reporter 2012 CU10 for Dynamics AX 2012 is now available!

    Management Reporter 2012 CU10 (version 2.1.10001.112 & w/ Hotfix 2.1.10001.126 - see below) 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...
  • 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: 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...
Page 1 of 2 (28 items) 12