Skip to content
Dynamics 365 Blog

Analysis scripts for Performance Analyzer v2.0 Page 6 

This is page 6 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 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...

Read more

Analysis scripts for Performance Analyzer v2.0 Page 7 

This is page 7 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 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...

Read more

Analysis scripts for Performance Analyzer v2.0 Page 8 

This is page 8 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 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...

Read more

Analysis scripts for Performance Analyzer v2.0 Page 9 

This is page 9 of 10 of the general performance analysis scripts online for the Performance Analyzer 2.0 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...

Read more

Performance for CRM 2016 Service Pack 1 and CRM Online 2016 Update 1 

Overview The Microsoft Dynamics CRM team has been testing the performance of Microsoft Dynamics CRM 2016 Service Pack 1 (SP1) (version 8.1) hosted on Microsoft Azure Virtual Machines. The goal is to establish a baseline for performance on CRM 2016 SP1, using Azure IaaS infrastructure with premium storage. The scenarios we have targeted involve thousands...

Read more

RDLC Report and Performance in Microsoft Dynamics NAV 2015 and 2016 

In a previous Blog dated back year 2014 https://blogs.msdn.microsoft.com/nav/2014/03/09/rdlc-report-and-performance-in-microsoft-dynamics-nav/ I have tried to give an overview related to the Out Of Memory exception that you might hit with Microsoft Dynamics NAV RDLC Report with the following versions: 2009 R2, 2013 and 2013 R2. The main focus of my dissertation now is based on the improvement...

Read more

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 deletes...

Read more

Performances hotfixes for the new Warehouse Management module 

Several partners and customers have raised support requests related to performances of the new WMS module. In addition to this, some code defects have been logged and addressed by Development. In the past months, several fixes and enhancements related to WHS performances were developed and released; these hotfixes were included in latest cumulative updates (CU9,...

Read more

Improve performance by running the Warehouse management on-hand entries cleanup job – for New AX and for AX2012 R3 CU10 

  Introduction Calculation of the on-hand are used from many forms but also during many business processes, the latter being less obvious to end-users. Therefore, it is always of interest to us to improve the performance of these operations since the overall impact on many processes can be quite significant. The nature of the queries...

Read more

How to proactively avoid parameter sniffing step-by-step 

In the following blog post the so called „parameter sniffing“ is explained: http://blogs.msdn.com/b/axinthefield/archive/2014/01/09/sql-server-parameter-sniffing-with-dynamics-ax-just-plain-evil.aspx The purpose of this blog post is to explain the fix implementation steps a little more in detail: Notes: The kernel only hotfixes mentioned for MS Dynamics AX in the blog post above are minimum prerequisites. Because all kernels are cumulative I’d...

Read more