My client is facing a serious workflow performance issue and have a lot of records end up with Error(stop). The workflow tables are very huge and have a lot of records in MessageQueueTable (few millions). It takes around 1 hour to assign to the approval or change the status (we schedule the batch job every 1 min).
We already separated the dedicated server for workflow with very high spec.
I would like to check if there any way to scale the workflow server? I have found a resource page for the workflow but it doesn’t mention anything regarding with load balancing or cleaning up the history workflow.
Have you encountered the same issue before? How do you resolve it? As I am app consultant with little knowledge in technical, I would like to have some idea which I can talk to my technical team.
thanks for your time. Appreciate your kind advice.