Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / SDK performance issues...
Dynamics 365 general forum

SDK performance issues on lightly loaded dynamics

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I'm new to the forums, so hello!

We have a live as well as a test/sandbox instance of dynamics 365 - both in the cloud. We are using the XRM SDK to pull/post data (including ecommerce transactions) between website and CRM. We have an apparent performance issue where the apparent response time from Dynamics appears to be a problem.

Our Developer used LinqPad to drive simple test transactions (account insertions) into our test/sandbox instance. The sandbox has no user traffic but it does have the 380+ workflows replicated from our live instance. By using LinqPad, we are removing the website element. During the tests we are seeing response times of up to 22 seconds. As I say, there were no user UI sessions at the time. I would expect such a transaction to happen very quickly (say a max of a second or so). 

In trying to figure out why it is taking so long, I am eager to learn what performance / loading diagnostics are available for the cloud-based Dynamics. I am interested in finding out what the recourse utilisation is overall and specifically for what processes/workflow.

But I'm new and cannot really identify anything through searching...

I would be very grateful if someone might be able to point me in the right direction on this, or a strategy for determining why the response time is to high.

Thanks

SimonDee

Categories:
General
Data Migrations
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SDK performance issues on lightly loaded dynamics

    Hello,

    Have You a resolution for this now ?

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SDK performance issues on lightly loaded dynamics

    I don't have a resolution for this yet.

    But I wanted to ask the community if there were resources that define the max response times over the SDK/API?

    I have seen the performance benchmark document (which is useful) but it doesn't really define the "maximum permitted response times" (SLA) for API calls.

    We are seeing times of 6 to 10 seconds to insert a contact record which is a bit slow. I would expect such a simple call to be quite fast (perhaps less than 1 second). When we are posting commerce transactions that uses multiple serial API calls, the time delay grows very long.

    BTW - we have contact deduplication turned off. Would this have an impact on performance?

    If anyone has links to Performance SLA documents, I would be very grateful.

    Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SDK performance issues on lightly loaded dynamics

    Hi Jeremy,

    Because we were in the cloud, we could not really get the range of diagnostics we (probably) needed (i.e. sql logs).

    Our CRM partner raised a ticket with Microsoft who are replicating the setup in their labs. I don't have any answers yet but I will post if we resolve the snag.

    Thanks

  • Medtexter Profile Picture
    Medtexter 308 on at
    RE: SDK performance issues on lightly loaded dynamics

    I am new to this SDK too!   Were you able to get this resolved?  What kind of performance are you seeing?    Thank you!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SDK performance issues on lightly loaded dynamics

    Raz,

    This is yet more useful information and guidance.

    Many thanks

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: SDK performance issues on lightly loaded dynamics

    Hi Simon , The Microsoft Dynamics CRM 2015 Performance Toolkit was created by the Microsoft CRM product team to formalize performance testing of Microsoft CRM 2013 and later releases. The performance toolkit can be used by the Microsoft CRM partners and customers to collect data to support their CRM deployment decisions.

    github.com/.../CRM-Performance-Toolkit

    Its going to be difficult to analyse the tables for CRM online as you can only do this with the assistance of an MS engineer as they only have access to your SQL, However what you can do is request a Backup copy of your CRM Database customisations and restore it to an on premise instance, allowing you to the monitor the behaviour of the transactions at SQL level.

    Best Wishes, Raz

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SDK performance issues on lightly loaded dynamics

    Raz,

    Thanks I appreciate your input. I l hear you on the locking/blocking thought and we will investigate that track, thanks. It makes sense.

    I know that diagnosing an on-premise solution would probably be easier, as we would have access to sql logs and the like. I think where we are failing to make progress is accessing core diagnostic information, such as performance, utilisation, loading etc. The problem may result from "stalled" workflows that are continuing to process, or indeed locked records as you say.  

    At this time, the CRM online instance is the part of the solution that we cannot "probe" or diagnose. The test queries are pretty straightforward and we have decoupled the website from the API for those tests. 

    Can you advise if there are add-on tools available so that we can see performance, utilisation, loading, as well as checking database status, logs, record locking or errors? Or do we need to engage a specific CRM partner-type?

    BTW the link in the referred article has changed. I found the report at http://download.microsoft.com/download/D/6/6/D66E61BA-3D18-49E8-B042-8434E64FAFCA/PerformanceBenchmarkforCRMOnline2016Update1.pdf

    Thanks again for your quick response and advice.

    Simon

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: SDK performance issues on lightly loaded dynamics

    Hi Simon, although Sandboxes are generally not as fast as production servers , you should still get results from queries faster than 22 seconds, unless the Slow response times are usually due to complete queries or locking / blocking occurring, so firstly review the query and the solution solution design.

    The following Performance Benchmark for Microsoft Dynamics CRM Online 2016 Update 1 document clearly shows the performance capacity technet.microsoft.com/.../mt791782.aspx

    Best Wishes, Raz

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans