SBX - Search With Button

SBX - Forum Post Title

ExecuteMultiplePerOrgMaxConnectionsPerServer

Microsoft Dynamics CRM Forum

xtremlylazy asked a question on 9 May 2019 2:38 AM

Question Status

Verified

Hi! We need to increase the ExecuteMultiplePerOrgMaxConnectionsPerServer limit to 20 on the organization gruppoagnsandbox.crm4.dynamics.com can anyone help us, please? How can we be sure that calls are not blocked by Microsoft protection system considering the high number? We are going to a start a performance test about the Initial Load (by SSIS/Kingswaysoft flow).

Cheers

Fabio Bottini

Reply
Pranav Shroti responded on 9 May 2019 3:37 AM
My Badges
Suggested Answer

Hi, can not comment if this high number is supported by Microsoft, however I would say why do you need so many connections to be open simultaneously. I dont know the exact scenario of your migration and data load, however in my past experience I have learnt that 4-6 connections are absolutely fine.

PS: MS has not published any upper limit of connections in their documentation.

Reply
xtremlylazy responded on 9 May 2019 7:45 AM

Thank you very much Pranav Shroti for your quick reply. Our developers think that a higher number of simultaneously connections could drammatically improve the initial loading time. We are going to load some hundred thousand records in a shot, and the loading time can be challenging.

Do you have any idea how to extend that parameter or to whom to ask for?

Thank you

Fabio

Reply
Pranav Shroti responded on 9 May 2019 11:20 PM
My Badges
Suggested Answer

You can use the following query to update the setting in CRM DB - in case of OnPrem.

update deploymentproperties set IntColumn = "20" where columnname = 'ExecuteMultiplePerOrgMaxConnectionsPerServer'

In case of Online you will have to raise a support ticket with MS. They will do it for you.

Hope this helps

Reply
xtremlylazy responded on 10 May 2019 2:54 AM

Thank you again Pranav!

Reply
Pranav Shroti responded on 10 May 2019 2:59 AM
My Badges
Verified Answer

Request you to close the thread by marking it as "Answered" if it helped you...

Reply
Pranav Shroti responded on 10 May 2019 2:59 AM
My Badges
Verified Answer

Request you to close the thread by marking it as "Answered" if it helped you...

Reply
Pranav Shroti responded on 9 May 2019 3:37 AM
My Badges
Suggested Answer

Hi, can not comment if this high number is supported by Microsoft, however I would say why do you need so many connections to be open simultaneously. I dont know the exact scenario of your migration and data load, however in my past experience I have learnt that 4-6 connections are absolutely fine.

PS: MS has not published any upper limit of connections in their documentation.

Reply
Pranav Shroti responded on 9 May 2019 11:20 PM
My Badges
Suggested Answer

You can use the following query to update the setting in CRM DB - in case of OnPrem.

update deploymentproperties set IntColumn = "20" where columnname = 'ExecuteMultiplePerOrgMaxConnectionsPerServer'

In case of Online you will have to raise a support ticket with MS. They will do it for you.

Hope this helps

Reply

SBX - Two Col Forum

SBX - Migrated JS