390
Hi,
We have been facing performance issues in MS Dynamics CRM 365 during create, update and retrieval operations. Is there any tool to analyze the probability of the performance for CRUD Operations.
For example we have identified one of the update entity in a plugin takes 12 to 23 seconds for one record which is awful. How can we identify what is causing the update operation to take that much time and how can we improve the performance.
Thanks.
*This post is locked for comments
Hello Jayakumar,
Please go through the link:
community.dynamics.com/.../248217
Please mark as answer if found useful.
Thank you,
Hi, just by looking at the problem, I could sense that it may be caused by SQL server, few things you can do to check that.
1. Check the configurations of SQL server, is it a virtual machine, single server or cluster .
2. Basic checks:
--Move Temp DB on another disk as it can slow down disk I/O operations
--SP_Configure
Check MAX_Configure_Memory
Check Run Flow Queries
Check Cascade queries
Check Fragmentation queries
--DVM Index
--Enable SQL table partition (only applicable in Enterprise edition)
--Change Isolation Level to 1 of Config DB and Org DB
--Check query:
Select * from ScaleGroupMaintainanceJobs
Change “NextRunJob” in maintenance window
--SQL Server compatibility mode 2012 can be switched off.
In my experience I have found many a times SQL server to be the culprit. I used few free tools to debug the issue:
YourKit Profiler for .Net: YourKit can profile any kind of CLR application, server, technology and framework; on various Windows and .NET framework versions; locally and remotely; in development, testing and production environment. This tool can be used to automatically monitor Async service performance
SQL Profiler: Can be used to debug, troubleshoot, monitor, and measure your application's SQL statements and stored procedures. SQL Profiler captures activity occurring in SQL Server, driven by requests from your client application. The tool enables you to select precisely which events you want to monitor.
Hope this helps.
Hello,
If you using Dynamics 365 V9, then I think you go with the "Organization Insights" Dashbaord in order to see the plugins execution performance.
Please go through the below links for more info:
www.powerobjects.com/.../how-install-view-organization-insights-dynamics-365
dyn365pros.com/.../use-organization-insights-to-diagnose-microsoft-dynamics-365-storage-issues
Please mark it as answer if found helpful.
Thank you,
Please add required log entries to plugin trace log if you have any custom plugin executions as part of CRUD operations
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,321
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
