Hi i have a performance issue regarding Logic Apps and a Azure Service bus queue.
So i have a logic app looking like this:
(NOTE: The delay is there to simulate a bunch of connectors/actions that take about 2 seconds to run, also i'm using lock tokens and also session IDs to complete messages and Close sessions)
Its polling the service bus every second for high throughput with a peak-lock because my service bus queue uses sessions to enable FIFO Ordering in my flow. So what i'm doing is, sending about 2000 messages with different session-IDs and also some that are alike depending on the message as they relate to each other sometimes (hens the fifo) to my service bus.
Enabling the Logic app after all the messages are in the Queue, my Logic App only processes 10 messages at a time. In other words it only scales up to 10 runs simultaneously.
This is far to slow, as those 2000 messages takes about 15 minutes to process. That's about 2-4 seconds per run, 10 runs at a time depending on the last 2 connectors that can take up to 1 second each to complete the message and close the session.
What i have done to try to solve this by trying for example:
Running the "When one or more messages are received in queue (peak-lock)" instead with message count delivery bumped up to 175 (max value). This results still in only one message getting polled, guessing this has to do with the sessions enabled for the queue.
Turned on "High Throughput" on the logic app, resulting in only up to 10 instances running simultaneously anyway, sometimes even fewer.
Turned off (and even turned on with max value defined) the switch for "Concurrency Control" on the trigger for the logic app. Still same results.
Scaled up the service bus to standard tier, still no luck.
Tried to clone the same logic app up to 5 times running them in parallell, still same result.
and much more..
(Worth mentioning, the messages aren't bigger than 1,5kb - 1,8kb)
What am i missing? I can't think of any other configuration to change, or any other ideas using this combination of logic app and session enabled service bus queues to try next. Should i maybe even upgrade the service bus to premium? I didn't think it was worth it because i haven't met the limits for the standard tier yet.
If i forgot to post any useful data please tell me and i will edit the question.
EDIT:
2018-04-06 10:00
I how now tried a type of “Sequential Convoy” type of solution which yielded in even worse results:
I followed this guide with some modifications: Sequential Convoy Guide
The modification i did was putting a "for each" loop instead of a "do until". The thing with this solution was that it took the "get all messages in queue" action about 30 seconds to search for a message in the queue containing the defined session ID, which is way to much. This also resulted in a weird behavior which made the logic app to scale less parallel runs too.
2018-04-06 16:00
Another test i tried now was trying to skip the service bus to test the instance scaling of the logic app, and sure enough posting directly from the API to the Logic app by the Http Post trigger in logic app, the logic app runs a lot more instances that with the service bus in between.
Which means that it is the service bus queue limiting the amount of instances being run by the logic app.
I cant find anything that fixes this problem, even by trying do clone the logic app to multiple amounts pulling from the same queue...
Any ideas on this?