Hi support,
I am experiencing some strange behaviour when the Scheduler service wants to start execution packages. The following is happening:
the schedule is supposed to start at every full hour. I know that it can take up to 2 minutes for an execution to actually start. Until last monday 18:00 everything was fine. The packages started within 2 minutes and were finished within 10 minutes.
After last monday 18:00, we are experiencing a delay in the start. Almost anytime the packages starts, it takes a 12 minutes delay.
It also looks like the execution takes way longer than 10 minutes. However, when I look at the gantt chart, I see it still takes up to about 10 minutes to finish. According to the screenshot below it was supposed to start at 03:00, it actually started at 03:12 but if you look closely at the actual times in the gantt chart it only started at 03:34 to finish at 03:42, which is still only 8 minutes.
It is TX v20.10.39.64. The database is Azure SQL, sometimes we use 100% CPU but given the reloadtimes are not affected we do not think this is the cause. The Azure Portal tells us we are allocating 445 GB of the reserved 600 GB.
When looking in the Event Viewer we find an error at last monday, 13 january, at 19:00. The time we first see the behavior happening. I have rebooted the application server but that doesn't seem to solve it.
I hope you guys can point me to a (possible) solution.
Best,
Remy