Microsoft Dynamics 365 Blog

Analysis scripts for Performance Analyzer v2.0 Page 8 

11 min read

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

0 Comments

Analysis scripts for Performance Analyzer v2.0 Page 9 

4 min read

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

0 Comments

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

2 min read

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

0 Comments

RDLC Report and Performance in Microsoft Dynamics NAV 2015 and 2016 

4 min read

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

0 Comments

Key Clean up Features for InventSum and InventDim Tables 

4 min read

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

0 Comments

Performances hotfixes for the new Warehouse Management module 

4 min read

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

0 Comments

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

3 min read

  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

0 Comments

How to proactively avoid parameter sniffing step-by-step 

1 min read

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

0 Comments

Creating and managing custom indexes in Dynamics AX 

2 min read

Hello, An index is a database structure that is used to speed the retrieval of information from a table, or in some cases to ensure the uniqueness of records in a table. In Dynamics AX, each table comes out-of-the-box with a variety of indexes designed to provide the best results in most cases. As every Dynamics AX…Read more

0 Comments

AX Performance – Analyzing key SQL Server configuration and database settings 

8 min read

In the previous post in this series, I provided some T-SQL scripts that can check key settings and highlight possible issues you need to address. This post aims to provide some feedback and suggestions on the information the scripts collect. There are of course different views on almost all SQL Server configuration settings, but the…Read more

0 Comments