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.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 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
For CRM 2013 on-premise version, we have configured email router to send email notification as majority of times user's outlook is not open and workflow was not able to send email through outlook
This creates performance related issue - it started executing following query so frequently which generates high wait time on server.
SELECT top 5 "email0".Subject as "subject" , "email0".Description as "description" , .... FROM Email as "email0" (NOLOCK) ...
Is there any alternate/solution to reduce this wait or an alternate to configure email router to reduce number of execution and logical read for the query mentioned.
I had similar performance issues with such SQL queries, but it was within the audit history on my side.
The SQL performance issue was related to the "top" part in the SQL statement on my side. Also adding non clusted index a.s.o. didn't help.
Without "top" the SQL statement ran fast.
On my side I could "solve" the issue by setting "enable quick find limit" to yes in the security settings.
You might want to give it a try.
Business Applications communities