locked
Too many workflow/plug-in executions? RRS feed

  • Question

  • Hello,

    With the current CRM implementation at the company I'm working for, there are 100-150 workflows/plug-ins firing every minute.  I did not design these and I'd like to hear from other folks if we have too many workflow/plug-in executions.

    CRM Implementation : CRM Online 2015 Update 1.1.

    Thanks.

    Thursday, October 15, 2015 6:06 AM

Answers

  • That number of executions is not excessive, and Crm should be able to cope fine with those from a performance perspective. If the workflows / plugins run asynchronously, then you should ensure the information about them is deleted regularly - the easiest option is for this to happen automatically when then are created, but if you need to keep the history for a while, then you could use a bulk deletion job to clear them up

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by AnSDE007 Thursday, October 15, 2015 8:58 PM
    Thursday, October 15, 2015 8:36 PM
    Moderator

All replies

  • That number of executions is not excessive, and Crm should be able to cope fine with those from a performance perspective. If the workflows / plugins run asynchronously, then you should ensure the information about them is deleted regularly - the easiest option is for this to happen automatically when then are created, but if you need to keep the history for a while, then you could use a bulk deletion job to clear them up

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by AnSDE007 Thursday, October 15, 2015 8:58 PM
    Thursday, October 15, 2015 8:36 PM
    Moderator
  • Thanks David.  This is exactly we were looking for.  The #records in the WorkflowLogBase table is approximately 50 million and the #records in the AsyncOperationBase table is approximately 10 million.
    Thursday, October 15, 2015 8:58 PM
  • Make sure that you set up you workflows to clean up the logs when they execute successfully.  That is an awful lot of workflow logs, and I'm betting that's not all active.

    The postings on this site are solely my own and do not represent or constitute Hitachi Solutions' positions, views, strategies or opinions.

    Friday, October 16, 2015 4:54 PM
  • Thanks Wayne.  I don't have much experience with CRM development and our lead CRM expert/consultant does not appear to be concerned.  That's why I'm reaching out to the community.  I just found out yesterday that we were creating 3000-4000 waiting system jobs a week and some of these waiting jobs could potentially wait forever.  I have a feeling that this could be another root cause on the slowness and intermittent failed workflows with our current implementation. 
    Friday, October 16, 2015 5:00 PM