Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
we have a big business unit structure and a strange issue which depends on it. Loading times of the "Active Accounts View" is very different from one business unit to the other business unit.
Attached you can find our structure (a part of it) and the number of accounts and the loading time as well. Tests were done from one location with the same security role in each business unit. Why there is such a difference between the loadig times?
All ideas are welcome!
I'm assuming that you don't have any plugin on RetrieveMutliple of accounts? If not and it's on-premise deployment, go to your SQL instance and use SQL Profiler to see which queries have the biggest impact on the performance.
I don't think that there is a dependency to a plug-in, because this is only a view. There is no plug-in execution when opening the view "Active Accounts".
It is an On-Premise deployment.
It does not matter if it's a view, if you have a plugin registered on RetrieveMutliple for accounts it will affect the performance. Make sure you don't have such plugin. Again I would go for SQL profiler and check query timing.
Your concern is genuine
Please raise a ticket to Microsoft for sql optimisation
We have raised a MS ticket. I will keep you up to date.
Thanks a lot!
problem was caused by a column which was defined in the view. After we removed the column. The loading time has decreased from 55 sec. to less than 3 sec.
Business Applications communities