locked
CRM 2013 - Internal query related to fetching top 51 emails RRS feed

  • Question

  • Hello All,

    We have recently upgraded from CRM 4 to CRM 2013. We are monitoring database server performance through one of the tool. We find that following internal query getting executed more frequently during initial business hours.

    (@ModifiedOn0 datetime,@PartyId0 uniqueidentifier)
    SELECT DISTINCT top 51 "email0".ModifiedOn as "modifiedon" ,  "email0".MessageId as "messageid" ,  "email0".ActivityId as "activityid" ,  "email0".RegardingObjectId as "regardingobjectid" ,  "email0".Subject as "subject" ,  "email0".RegardingObjectIdYomiName as "regardingobjectidyominame" ,     "email0".RegardingObjectIdName as "regardingobjectidname" ,     "email0".RegardingObjectTypeCode as "regardingobjecttypecode" 

    FROM Email as "email0"  JOIN ActivityParty as "activityparty1"  ON ("email0".ActivityId = "activityparty1".ActivityId 
    AND (("activityparty1".PartyId = @PartyId0))) 

    WHERE (( "email0".ModifiedOn >= @ModifiedOn0 
    AND "email0".MessageId is not null)) 
    ORDER BY "email0".MessageId asc , 
       "email0".ActivityId asc

    I found following useful blog which mentions the reason of frequent execution of this query.

    https://community.dynamics.com/crm/b/dynamicscrmsupportblog/archive/2012/10/11/crm-e-mail-tracking-part-3-tagging.aspx

    My question is,

    1) What will be impact if we disable email tagging option from all users? Note that, We are not using email router in our implementation.

    2) Will this query executes frequently during normal business hours also? If yes, then do we have any settings to change interval of execution of this process? 

     

     

     

    Friday, April 17, 2015 1:56 PM

All replies

  • Hi ,

    Try to deactivate the Automatic E-Mail Tagging from Diagnostic Tool and observer the behaviour.

    If it still trigger then better to look for other areas.

    Regards


    Ayaz

    Wednesday, April 22, 2015 11:04 AM