30
Hi,
I work on dynamics crm 8.2 on premisse. The contact entity has over 10M records.
When i try to create a marketting list over 200K based contact , the browser are freezing.
How can i monitor the process?
*This post is locked for comments
Hi David,
I followed the three steps based on your advice.
After below steps, i could create a list that has 2M records.
1. I change the HttpRunTime value in web.config.
2. I change the db timeout value in HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSCRM
3. Finally, i change one of dynamics crm store procedures : p_AddMarketingListMembers
That is a lot of records. You can increase various timeouts, see https://blogs.msdn.microsoft.com/crminthefield/2011/06/13/microsoft-dynamics-crm-timeout-settings/
The article was written for CRM 4 / 2011, but the settings still apply for CRM 8.2
If you can, it's worth trying to capture the SQL queries that are submitted, to see if you can add indexes that will optimise this. You can get the SQL queries either via verbose CRM tracing, or SQL trace, though in either case a lot of trace data gets generated if you do this during normal operation. If you could, I'd create a copy of the organisation database just to test this, and use SQL trace just on that database
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
Victor Onyebuchi
6
Share
Report
All responses (
Answers (
