Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Unanswered

Performance issue saving data to custom entities - on prem 2016 CRM (Create and ExecuteMultiple)

Posted on by 5

Hello

I have recently been put in charge of a custom built ASP.Net system which uses CrmServiceClient to perform some work on  2 custom entities. Our CRM is on-prem in a VM. Sql server is on another VM.

These entities are rather simple,  a simple hierarchy - parent->child one level  - 1 to many relationship, nothing fancy, no plugins, no custom workflows, no events.

You could says that these entities are only used for data storage,. in CRM the parent entity has one standard main Information form and a view on it  for a list of child entities.

Lately  we've been experiencing a huge slowdown when trying to insert more than twenty rows at the time through _client.Create.  I firsrt blamed the ASP.Net app and optimized the code,

but it made no difference. Then I asked a colleague to monitor server and the VMs for abnormal load when i execute insert operations and there was no notable increase in load. On CRM machine one CPU core of 8 was peaking at like 60 % and no memory spikes. Neither SQL server and its VM showed any signs of struggle.

So I'v changed the code again in ASP.Net app and instead of create each child row one by one, I  ran with ExecuteMultiple request passing in about of three hundred child rows of data.

That , amazingly, did nothing at all... It takes approximately 5 minutes to insert 300 rows   either via _client.Create  or ExecuteMultiple.   And what's more interesting it take about 5-6 minutes to delete them through CRM's own interface  via parent entity form , clicking "Delete"...

Right now I am clueless...  

  • DmitriyP Profile Picture
    DmitriyP 5 on at
    RE: Performance issue saving data to custom entities - on prem 2016 CRM (Create and ExecuteMultiple)

    Hello

    Thanks for your reply,   but  I've tried that.

    I have measured time it takes for 300 rows, and divided by 300 to get  time per row, which is  approximately 1.4 seconds

    When I reduce ExecuteMultiple request size to any number of rows (200,150,100)  it still takes the same amount of time per row.

    Redards

    D

  • Pradeep Rai Profile Picture
    Pradeep Rai 5,490 Super User on at
    RE: Performance issue saving data to custom entities - on prem 2016 CRM (Create and ExecuteMultiple)

    Hi,

    Can you please try by reducing the batch size from 300 to 100 rows or less?

    Thanks,
    Pradeep.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans