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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (