Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

CRM 2016 (8.2.2) On Premise Async High CPU Utilization

  • 1.  CRM 2016 (8.2.2) On Premise Async High CPU Utilization

    TOP CONTRIBUTOR
    Posted May 02, 2019 05:35 PM
    We're experiencing CPU spikes during high usage of the async services on our CRM server.  While it is not causing major slowness issues (yet), it is causing our monitoring system to alert us when it happens.  That monitoring has allowed us to narrow this down to Async.  Does anyone have a way to either reduce this CPU usage or to put Async in a box (like you can SQL services) so that it only gets a maximum of say 80% of the CPU to use not matter what it's doing?  That way there would be always 20% CPU available for other work.

    Donna

    ------------------------------
    Donna Liotta
    Manager Business Applications
    National Safety Council
    Itasca IL
    ------------------------------
    CRMUG Summit - Post


  • 2.  RE: CRM 2016 (8.2.2) On Premise Async High CPU Utilization

    GOLD CONTRIBUTOR
    Posted May 03, 2019 12:05 PM
    Hi Dona

    We have installed the asynchronous server and a couple of other windows services on a separate box.
    See MS instructions here
    https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/deployment-administrators-guide/jj612874(v=crm.8)

    Since all those services are asynchronous, we don't really care whether the CPU has spikes. The Operating system will take care of allocating the resources to all services.

    Thanks

    ------------------------------
    Christian J. Betrisey
    Software Developer
    American College of Emergency Physicians
    Irving TX
    ------------------------------

    CRMUG Summit - Post


  • 3.  RE: CRM 2016 (8.2.2) On Premise Async High CPU Utilization

    Posted May 03, 2019 12:32 PM
    Are you using Server Side Sync? We had the same issue.
    The CRM is generating some long running queries on the CRM SQL server if certain CRM sync filters are in place.  If the Parent Downloaded parameter is used when synchronizing CRM data to Exchange, increased query execution times can result.  It may be beneficial to run the following query to determine how many users could be impacted by this:

    The following script was used to determine how many users have this filter in place:
    Run this query on DB and rest the sync filter if there is any problem.
    /*Select Sync filter causing problem*/
    select su.fullname, su.InternalEmailAddress from UserQueryBase ub
    join SystemUserBase su on su.SystemUserId = ub.OwnerId and ub.QueryType = 256
    where ub.FetchXml like '%condition attribute="primarykey" operator="child-of"%'
    AND su.IsDisabled=0

    ------------------------------
    Senthil Mani
    AgFirst Farm Credit Bank
    Columbia SC
    ------------------------------

    CRMUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role