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 – 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: 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: Management Reporter 2012 CU9 for Dynamics AX 2012 is now available!

    Management Reporter 2012 CU9 has been posted for download! This release contains enhancements to the Management Reporter Web Viewer around opening and refreshing reports along with additional troubleshooting information in the Configuration Console related to data issues in Dynamics AX. Here’s...
  • 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: 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: 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: Dynamics AX 2012 Cumulative Update 7 (CU7) is now released!

    In case you missed it, I’m happy to relay we recently released Dynamics AX 2012 R2 Cumulative Update 7! CU7 includes enhancements to several modules or feature areas, including the highly anticipated Data import, export, migration improvements , and integration with Lifecycle services . AX 2012...
  • Blog Post: Dynamics AX, Index Fragmentation, and You.

    I have been onsite at a lot of Customers who believe that Index Fragmentation is major influence on overall Performance for Dynamics AX. I actually have a hard time convincing them that its impact is relatively low on overall performance. They also raise the issue that they can no longer fit their re...
  • Blog Post: Payroll for Dynamics AX: New Tax Updates available

    New tax updates for Payroll for Dynamics AX are available for download. Find the latest updates at the links below. Enjoy! Microsoft Dynamics AX 2012 US Payroll The AX 2012 Payroll tax update 2013-R11 contains the updated tax engine. AX 2012 Payroll tax update 2013-R11 now available (KB2872380...
  • Blog Post: Dynamics AX 2012 and SQL Server 2012 AlwaysOn Availability Groups

    When setting up Microsoft SQL Server 2012 AlwaysOn Availability Groups with Microsoft Dynamics AX 2012 you may run into an issue when attempt to enable the “Partial Containment” option on the Dynamics AX production database, which is a pre-requisite for AlwaysOn. When you attempt to enable...
  • 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: The Microsoft Dynamics AX Technical Conference 2012 is coming soon!

    We're getting close to the launch of Microsoft Dynamics AX 2012 R2 and the opportunity to learn all about it (and AX in general) at the Microsoft Dynamics AX Technical Conference 2012. This year's event will be held in Bellevue (Seattle), WA where you'll have access to the best and brightest minds on...
  • Blog Post: Compatibility Testing for Microsoft Dynamics AX

    [Updated for SQL Server 2012 and SharePoint 2013] When reviewing the Dynamics AX environment on customer site, we are often been asked question such as: “Do you know if this version of the product is officially supported by Microsoft”? This is quite natural because Microsoft products...
  • 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...
Page 1 of 1 (18 items)