Microsoft Dynamics 365: Business Central: Working with Procurement (Part 1)
February 21, 2020
Power BI Report in Dynamics 365 Finance And Operations
March 2, 2020Performance Optimization – Dynamics 365
Performance Optimization - Dynamics 365
Hi Everyone,
This post will present the different tools that can be used to troubleshoot Microsoft Dynamics 365 for Finance and Operations performance issues.
I have heard several times that optimizing a cloud hosted Dynamics 365 FO is not possible , and also performance problems are Microsoft responsibility. This is so wrong!
It is possible to optimize a Dynamics 365 FO installation, and you are able to monitor and optimize your live installation more or less as in previous versions of Dynamics like AX 2012. In fact, in some areas it has become easier to identify bottle necks in the system. The main problems to poor performance on Dynamics 365 for Finance & Operations are usually customized code or lack of following Microsoft's guidelines for maintenance of the live system. Where Microsoft's guidelines used to be advise on how to improve quality of your installation, it is now crucial that your understand and adapt Microsoft's guidelines for Dynamics 365 Finance and Operations.
Using the following sources will help you identify bottlenecks in your cloud hosted Dynamics 365 Finance & Operation environment.
Lifecycle Services (LCS) Environment Management
- Monitoring and diagnostics tools in Lifecycle Services (LCS) https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/monitoring-diagnostics
- Performance troubleshooting using tools in Lifecycle Services (LCS) https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/performancetroubleshooting
- Query cookbook https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/querycookbook
- Take trace of isolated performance issue https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-trace-tutorial
https://blogs.msdn.microsoft.com/axsupport/2017/11/15/collect-dynamics-365-for-finance-and-operations-event-traces-with-windows-performance-monitor/
- Analyze trace using Trace Parser tool https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-parser
- Performance timer (on PROD without Server details) https://yoursite.cloudax.dynamics.com/?cmp=USMF&debug=develop
https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/performance-timer
- F12 browsing tools
- When running in debug mode you will notice slower performance
- As an alternative; you can quickly get an overview of most performance issues by pressing F12 and working with the debugging tools that are available in your browser
- Monitoring performance by using the Query Store https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
- Query Store Usage Scenarios https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-scenarios
- Optimization advisor https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/sysadmin/optimization-advisor-overview
Let me know if you need any advise on optimizing or customizing your Dynamics 365 for Finance and Operations.
