web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Dynamics CRM Create, U...
Microsoft Dynamics CRM (Archived)

Dynamics CRM Create, Update and Retrieve Performance

(0) ShareShare
ReportReport
Posted on by Jayakumar 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

I have the same question (0)
  • Rajesh Chungath Profile Picture
    Rajesh Chungath 467 on at

    Please add required log entries to plugin trace log if you have any custom plugin executions as part of CRUD operations  

  • Jayakumar Profile Picture
    Jayakumar 390 on at

    Hi Rajesh,

    We found the issue by adding trace logs in one of the plugins for an update entity. There is no other plugin for this update. Now we have to identify what is causing the time for updation.

  • Suggested answer
    Jeet Gandhi Profile Picture
    Jeet Gandhi 320 on at

    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,

  • Jayakumar Profile Picture
    Jayakumar 390 on at

    HI Jeet Gandhi,

    Ours is on-premise. Where to get the solution to install in on-premise version.

  • Suggested answer
    PranavShroti Profile Picture
    PranavShroti 4,510 on at

    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.

  • Suggested answer
    Jeet Gandhi Profile Picture
    Jeet Gandhi 320 on at

    Hello Jayakumar,

    Please go through the link:

    community.dynamics.com/.../248217

    Please mark as answer if found useful.

    Thank you,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans