Dynamics AX in the Field
Microsoft Dynamics AX from the Premier Field Engineering team at Microsoft.
AX 2009 Retail
AX 2012 R2
Cumulative Update 7
Data Management Framework
Database growth in Dynamics AX
Database Synchronization Process
Determining Number Sequence
document process in Ax
Dynamics AX 2009
dynamics ax 2012 r3
dynamics ax 2012 r3 azure lcs lifecycle services demo vm
Dynamics AX 4.0
Dynamics AX CRM DynamicsPerf Dynperf SQL Server Performance
dynamics ax deployment instances
Dynamics AX Event IDs
Dynamics Ax Retail
Dynamics AX SL NAV GP Performance DMV
Dynamics DynamicsPerf Dynperf AX CRM Baseline
Dynamics DynamicsPerf Performance Analyzer
DynamicsPerf Dynamics AX SQL Server
DynamicsPerf Dynamics AX SQL Server Premier Field Engineering
lock escalation and blocking
Long Running Queries
Managing the alerts Queue for AX 2009
Microsoft Dynamics AX 2012
Performance Analyzer for Dynamics
Preallocated Number Sequence
SQL Server 2008 R2 SP1
SQL Server 2012
Browse by Tags
Dynamics AX in the Field
Tagged Content List
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...
6 Nov 2014
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...
4 Nov 2014
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...
3 Nov 2014
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...
29 Oct 2014
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...
26 Sep 2014
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...
13 Jan 2014
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...
9 Jan 2014
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...
4 Nov 2013
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...
24 Oct 2013
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...
1 Aug 2012
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...
22 Jun 2012
Dynamics Ax 2009 Retail Error Messages & Possible resolutions
Dynamics Ax 2009 Retail Error messages & Possible resolutions: Error Code Title Error Description Possible Resolution 0 Error on sending request The distribution server for the location has not been specified in Retail...
22 May 2012
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...
1 May 2012
AOS Load Balancing
I've been questioned several times recently about AOS load balancing in Dynamics AX, and there seems to be quite a bit of confusion about how to properly configure AX for AOS load balancing, as well as high availability. Here are a few clarifications that apply to Dynamics AX version 4.0, AX 2009 and...
20 Jan 2012
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...
25 Jun 2011
AX 2009 - How to Transfer Security Settings to a Production Server
Summary: If you are in a situation where you have created your AX security settings on another AX instance and you now need to move them to your production server, below are a few options for how to accomplish this. Assumptions: This is a one-time transfer from the STAGING server to the...
23 Jun 2011
AIF File Adapter for AX 2009 - Security Authorization
Summary To properly test your xml documents for use with the Application Integration Framework (AIF) in AX 2009, it is best to use the File Adapter as it is easy to set up. You can use any Adapter for when you go-live. It is important to understand how the AIF file adapter security authorization...
23 Jun 2011
Choosing a Single Deployment or Multiple Deployments of AX2009
Multiple AX 2009 Deployments versus a Single Deployment Dynamics AX2009 has the capability to run a single deployment supporting multiple companies within the same database. There are some considerations when deciding whether to have a single deployment of AX2009 or multiple deployments for each of...
14 Jun 2011
Optimizing AX Batch Performance - Batch Thread Configuration
Are you pushing a lot of transactions through the AX batch framework? Are you wondering if you've optimized the system for your workload? We recently did some testing in our lab to illustrate some of the performance and concurrency characteristics of the AX 2009 batch framework. Our goal was to show...
13 Jun 2011
Financial Consolidations - Dynamics Ax 2009 (Part 2)
Please find the Part1 here . III) Perform a Consolidation: Options to perform consolidation: From the same database using the online option From and, or to another database using the Import/Export option Before you perform a consolidation at the close of a period, ensure that the...
10 Jun 2011
Financial Consolidations - Dynamics Ax 2009 (Part 1)
Financial Consolidations process: 3 steps to perform consolidation in Microsoft Dynamics Ax 2009. I ) Consolidation company setup II) Subsidiary company setup III) Perform consolidation I) Consolidation company setup: Consolidation company creation: Consolidation designated company...
10 Jun 2011
How the Database Sychronization Process works in AX 2009
The Database Sychronization process within AX 2009 sychronizes the table information to the database by creating all the tables and indexes it needs to operate. This synchronization is necessary when there are schema changes in the Application Object Tree (AOT) and must be populated to the database....
10 Jun 2011
Permission Comparision Examples between User Groups and Domains in AX 2009
When working with customers I have encountered many scenarios where the User in which they are trying to setup security permissions belonged to multiple User groups or had different permission sets in different Domains. Permissions are compared between User groups and Domains using the least restricive...
10 Jun 2011
XBRL Taxonomy (Import & Export of reports)
XBRL : eXtensible Business Reporting Language (XBRL) (Global Financial Reporting initiative) Reporting: Financial statements, information, non-financials information and regulatory filings. Use the XBRL feature in Microsoft Dynamics AX 2009 to: Import taxonomies Convert taxonomies into...
7 Jun 2011
Automatic transactions in AX 2009: System Accounts
Automatic transactions in AX 2009: System Accounts Systems accounts are used for automatic transactions in Dynamics Ax. In the systems account form we add various automatic accounts on the basis of posting types. The following transaction types can be posted in case setup is missing. Path: Dynamics...
6 Jun 2011
Page 1 of 2 (28 items)
© 2014 Microsoft Corporation.
Privacy & Cookies