Read this in conjunction with part 1
Dynamics Perf
This toolset includes SQL scripts to collect SQL Server DMV data. It also gathers Microsoft Dynamics specific product data. This data is persisted into a singular database called DynamicsPerf. This allows for quick resolution of performance issues on Microsoft Dynamics products (CRM, AX, GP, NAV, SL)
Setup and files could be downloaded from here
Collect AOS table data information.
- Capture Microsoft Dynamics AX performance data.
- Capture Application Object Tree (AOT) metadata.
- Collect locking/blocking and other information.
- Ensure that the blocked process threshold for SQL Server is set to at least 2.
- Capture a SQL Trace (Server Side Profiler Trace).
Intelligent Data Management Framework(IDMF)
The Intelligent Data Management Framework for Microsoft Dynamics® AX helps administrators optimize Dynamics AX database layout. It provides functionality to manage key database layout techniques. This is achieved by way of intuitive Archiving and Purging capabilities. The framework enables a reduction in database size. It does this by purging and archiving transaction records from sets of related entities. At the same time, it maintains the consistency and integrity of production data.
configuring this is out scope here .
Visual Studio Profiling Tools to trace CIL
Trace Parser can’t effectively trace batch processes, services, and code that traverses CIL by using the RunAs() command. Instead, you must use the Visual Studio Profiling Tools.
Beginners Guide to Performance Profiling – Visual Studio 2015 | Microsoft Learn
Performance SDK and task recorder
could be used to analyze performance issues in D365 FO. A performance test script is generated by using Task recorder for this purpose.
Follow below link for setup.
Elastic Stack (Diagnostics)
This is a third-party product. It is one of many choices that can offer diagnostic monitoring of your D365 on-premises solution.
The stack includes
- Elasticsearch – For storage, event indexing, and event querying. For more information about Elasticsearch, see the Elastic website.
- Logstash – For load distribution and event data transformation.
- Winlogbeat – For diagnostic data collection.
- Kibana – An interface for querying the data that is stored in Elasticsearch.
Setting this up is out of scope here .
Performance Timer.
This is built into D365 FO. To open the Performance timer, add the parameter debug=develop to your webpage URL. Then, open your webpage: https://yoursite.cloud.test.dynamics.com/en/?cmp=USMF&debug=develop
Note: When you run in debug mode you will notice slower performance. You can quickly see most performance issues. Press F12 to work with the debugging tools available in your browser. The timer will show up here. see the link for more details.
https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/perf-test/performance-timer
One Reply to “AX / D365 Performance monitoring tools and tips (Part 2)”