GlenTurnbull articles
GlenTurnbull
Intermittent Inventory On Hand Performance Issues
A few customers have reported intermittent performance issues involving inventory on hand related queries on the InventSum, InventDim and/or WHSInventReserve tables, due to bad query plans regarding the table joins. This not only applies to on hand inquiries necessarily, but anything else dependent on it, e.g. inventory related posting processes, e.g. purchase invoicing. So based
Published
4 min read
Key Clean up Features for InventSum and InventDim Tables
Author: Arnold van Wageningen Please find below a summary of the clean-up features we currently offer in regards to InventSum and InventDim tables which can be found under the menu: Inventory management > Periodic > Clean up. The Inventory Dimensions cleanup shows the following help text: “The ‘Clean up unused inventory dimensions’ batch process deletesCalling AX 2012 Business Logic from SSIS Using a Script Task and Custom Web Service
This relatively simple example demonstrates how you can call AX business logic from SSIS by connecting to a custom web service. It assumes some knowledge of the individual technologies themselves. The underlying business logic for our custom web service in AX 2012 returns a message based on a parameter of type integer passed into it
Published
2 min read
Dynamics AX Table Caching: Basic Rules
This post provides some basic general guidance to get you started on setting table caching for custom tables, bearing in mind there will be exceptions. This should generally be defined at design time to avoid costly round trips to the database. As explained by Bertrand Caillet from our PFE (Premier Field Engineering) team: “This is
Published
2 min read
Troubleshooting that elusive “slowdown” in AX using Performance Analyzer 1.20 for Microsoft Dynamics
It’s 9.30am on Monday morning and you’ve just received reports of a “general slowdown” on Microsoft Dynamics AX. After probing further you find it was all over by 9:15am lasting around 15 minutes, but also happened once before and the users want action taken to prevent it happening again. There are never any guarantees when
Published
2 min read
Collect a series of traces automatically with Dynamics AX 2012
Introduction The following steps are one way to collect a series of AX traces on a schedule with all versions of AX 2012 on the AOS server, using standard Windows tools: Perfmon combined with Task Scheduler. This example collects a 1 minute trace at 5 minute intervals. This can be useful for example if you
Published
10 min read
Managing general performance issues in Microsoft Dynamics AX
Updated on 09/09/16 for DynamicsPerf v2.0. Intended for versions up to AX 2012. This post is primarily aimed at non technical readers and those responsible for coordinating or managing these issues, but with links drilling through to more in depth blogs containing further details. By ‘general performance’, I mean a set of unidentified performance issues
Published
1 min read
Microsoft Dynamics AX general performance analysis scripts page 8
This is page 8 of 8 of the general performance analysis scripts online for the Performance Analyser 1.20 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published
1 min read
Microsoft Dynamics AX general performance analysis scripts page 7
This is page 7 of 8 of the general performance analysis scripts online for the Performance Analyser 1.20 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published
8 min read
Microsoft Dynamics AX general performance analysis scripts page 6
This is page 6 of 8 of the general performance analysis scripts online for the Performance Analyser 1.20 tool. See page 1 for the introduction. Use the links in the table below to navigate between pages. – General analysis Analyse SQL Configuration Page 1 Analyse SQL Indexes Page 2 Analyse SQL Queries Page 3 Analyse Blocking
Published
17 min read