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: How to manage Windows NLB when AOS Service stops

    Consider the following scenario where there is an AOS Cluster configured for Services' high availability by following the information published at “Configuring network load balancing for services AX2012” ( http://technet.microsoft.com/en-us/library/hh397322.aspx ) The NLB cluster is working...
  • 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: 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: Dynamics AX and little Orphaned SPID Annie

    One of the top questions I am asked by customers when I am on site is what causes AX Orphaned SPIDS and what to do with them and how to identify them. As we know Orphaned SPIDS can cause blocking which lead to end user frustration. They are usually caused by users not exiting the AX application correctly...
  • Blog Post: Announcing RAP as a Service for Dynamics AX

    I am pleased to announce the General Availability of RAP as a Service for Dynamics AX . This Microsoft Premier Service takes our existing Health Check to the next level with on-demand data collection and analysis to give you the flexibility to check and re-check the state of your system whenever you...
  • 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: 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: Comparing AX and Active Directory User Accounts

    I was recently working with an AX 2009 customer who wanted to compare the user accounts configured in AX with the user accounts in Active Directory. The basic goals were: Find all AX user accounts that no longer exist in Active Directory. Find all accounts that are disabled in Active Directory...
  • Blog Post: Managing the Alerts Queue for AX 2009

    It is important for Administrators to manage the Alert rules in your AX system. I have seen many instances where the EventCUD table is extremely large which means many Alerts are queued up. The EventCUD table stores the changed-based Alerts that are waiting to be sent and will continue to grow until...
Page 1 of 1 (14 items)