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.Key Clean up Features for InventSum and InventDim Tables
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.Calling 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.
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.
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.
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.
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.
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.
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.
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.
Published
17 min read