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: 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: 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: 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: Efficient Dynamics AX Application Lifecycle Management approaches with Team Foundation Server in the cloud

    Premier Field Engineering is delivering many Code Review for Dynamics AX all over the planet. One thing we often face is the fact that a real Application Lifecycle Management (ALM) approach is not in place . Real application lifecycle management and even a proper version control with Team Foundation...
  • Blog Post: What time is it? Another new feature in Performance Analyzer for Microsoft Dynamics ( DynamicsPerf )

    In the next release of Performance Analyzer for Microsoft Dynamics (DynamicsPerf), we will be making a schema change to the AX_SQLTRACE table. Currently, the [CREATED_DATETIME] column is stored in GMT time. Dynamics AX stores it this way to adjust for clients being in multiple time zones. So, in our...
  • Blog Post: Drip, Drip, Drip time to patch SQL 2012 SP1

    For those Dynamics customers on SQL Server 2012 Service Pack 1 or above, Cumulative Update 7 is released http://support.microsoft.com/kb/2894115 . There are 2 memory leaks that have been patched that impact Dynamics AX: http://support.microsoft.com/kb/2881661 http://support.microsoft.com...
  • 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: 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: 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: We Are Hiring!

    Are you ready to be a Rock Star?? Do you enjoy supporting Microsoft technologies and sharing technical information with others? Are you a motivated individual who enjoys working in a team-oriented environment? Are you passionate about working with customers and solving complex situations? Do you enjoy...
  • Blog Post: Benchmark your Dynamics AX solution with Load Testing

    One of the most crucial time when implementing your Dynamics AX solution is the few weeks prior the Go Live. At that stage, the infrastructure has been configured with all components and all settings have been reviewed to match best practices. The functional team is running all test cases to sign off...
  • 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: 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: 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: Interviewing AX Candidates - What I Look For (Part 1)

    As I mentioned in the post about tamping someone up on AX, I look for candidates who have expertise in AX Performance, AX Application (at least one particular module) or AX development. Because of this, we have to bring in the right people on the team and ask the right questions to determine if our candidate...
  • Blog Post: Ramping Someone Up on Dynamics AX

    What does it take to learn Dynamics AX? It's not for the faint of heart - the product takes years to master and there's still no one I've met who knows every inch of it backward and forward. First, you have to start by finding the right candidate, so you have to know what you're looking for. Let's...
Page 1 of 2 (34 items) 12