Impact of a workflow in Waiting state for long time

(0) Share

Report

Posted on by Community Member

Hi. A workflow in Waiting state for very long time may have impact on performance for CRM On-prem. Can this also impact the performance for CRM Online?
Thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Yes it will also impact on the performance

Was this reply helpful? Yes No
Suggested answer

razdynamics 17,308 User Group Leader on at

Like (3)

Report

Hi Saima

CRM Online has a limitation of 200 long running workflows, so this could eventually have an impact on your Async Service, I recommend you review the construction of your workflows,

feel free to share the workflow screenshot of the steps where its getting stuck

Best Wishes, Raz

Was this reply helpful? Yes No
Suggested answer

Ozarour 630 on at

Like (1)

Report

You should also take care of the number of records in the AsycnOperation table, because if it has 1 million or more records, then you will be exposed to failure in async jobs because of lock problems, for example you will find that many simple workflows throws exception of cannot obtain lock on table x because of the too many records in the Asycnoperation table.

support.microsoft.com/.../968520

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you all, this is helpful.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Raz,

where can I check what that limit currently is? Need to check if it's still 200 and/or if they're planning on updating that limit for v9

Thanks

Was this reply helpful? Yes No