This is the second page of Part 1, in a two part troubleshooting check list for general performance on Microsoft Dynamics AX. This page (Part 1B) covers AX application and AOS configuration settings.
Please see the previous page for the introduction and Part 1A of the check list, which covers SQL Server and Storage Settings. Part 2 (following on later) will cover hardware, indexing, queries, blocking and code (at a high level).
Below there is also a link to a script you can use to gather some of the required information from your system. It requires the Performance Analyser 1.20 to be installed first.
Part 1B: AX application and AOS configuration settings
Analysis script: http://blogs.msdn.com/b/axsupport/archive/2014/09/01/microsoft-dynamics-ax-general-performance-analysis-scripts-page-6.aspx
Some settings can be checked manually in the application (steps given in the links below) or AX Server Configuration Utility (Start > Administrative Tools > Microsoft Dynamics AX Server Configuration).
Kernel & Application Builds
*Further details: Number sequence overview [AX 2012] **Explanation: http://blogs.msdn.com/b/axinthefield/archive/2011/05/02/how-preallocated-number-sequences-are-cached-in-ax.aspx
Number sequences (form) [AX 2012]: http://technet.microsoft.com/EN-US/library/hh209531.aspx
AX 2009: "Introduction to AX 2009" training materials on Partnersource or Customersource, e.g. https://mbs.microsoft.com/customersource/Global/AX/learning/student-training-materials/course80020(Chapter 5)
Determining what pre-allocation to set: use the script provided in Performance Analyser 1.20, in the folder: Analyze AX Configuration, "Analyze AX Configuration", section "NUMBER_SEQUENCE_USAGE"
Database logging and alerts:
Configure and manage database logging [AX 2012]:http://technet.microsoft.com/en-us/library/dd362089.aspx
AX 2009: "Administration in Microsoft Dynamics AX 2009" training materials on Partnersource or Customersource, e.g. https://mbs.microsoft.com/customersource/Global/AX/learning/student-training-materials/courseAX2009ADM (Chapter 6 - alerts)
Extensible Data Security (XDS) / Record Level Security (RLS):[RLS will be removed in a future version]
Developing Extensible Data Security Policies (White paper) [AX 2012]http://technet.microsoft.com/en-us/library/hh272862.aspx
Manage record level security [AX 2012] http://technet.microsoft.com/en-us/library/aa570084.aspx
Manage record-level security [AX 4.0 & 2009]: http://www.microsoft.com/en-us/download/details.aspx?id=10680
-Turn off any other configuration keys which are not required (for similar reasons to those above and it is also potentially skipping additional logic in the code which is not required).
Configure application functionality [AX 2012]:http://technet.microsoft.com/EN-US/library/aa496468.aspx
AX 2009: "Administration in Microsoft Dynamics AX 2009" training materials on Partnersource or Customersource, e.g. https://mbs.microsoft.com/customersource/Global/AX/learning/student-training-materials/courseAX2009ADM(Chapter 1)
Entire table caching:
Best practices for table properties:http://msdn.microsoft.com/en-us/library/aa632254.aspx
AX 2012 entire table cache size setting:http://msdn.microsoft.com/EN-US/library/bb314693.aspx (section: 'configuring the cache sizes')
As a rough guide (at your own risk, bearing in mind there can be exceptions including the above EntireTable best practices), you can use the following approach:
[AX 2012 only]Client performance options:
[AX 2012 only]Server Configuration - Performance Optimization:
Server Configuration - Batch server schedule:
AX 2009:Administration > Setup > System > Server configuration
AOS Configuration settings
Manage an AOS configuration: http://technet.microsoft.com/en-us/library/aa569618.aspx
Application Object Server options: http://technet.microsoft.com/EN-US/library/aa569637.aspx
Divide the number of AOS processors equally among the instances, e.g. with 4 processors and 2 AOS services on one machine: processors 1 & 2 = AOS instance 1, processors 3 & 4 = AOS instance 2.
Set processor affinity [AX 2012]:http://technet.microsoft.com/en-us/library/dd309629.aspx