Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have setup monitoring based on Qlik Replicate Task PERFORMANCE logs and I can see one of my task (Logstream -> Snowflake) keep repeat the same pattern everyday where the latency kept on increasing (to couple hours) and then suddenly drop to less than 100 seconds. (Image below)
One thing makes it hard for me to understand is because source table has no changes for a while now but this pattern keeps on repeat.
May I ask how should I identify the source of latency in this case and should I base my monitoring on pending changes rather than PERFORMANCE data?
Thank you for your help
Hi @toanlc
During this time of source latency on the child task, is there also latency on the parent task?
Does the parent task tables for this child task have a pattern of long running transactions before they are committed?
Thanks,
Dana
Hi @Dana_Baldwin,
Thanks for having a look.
When this happens, the parent task has almost no latency or just a few ms.
The table has only 86 rows and not been updated for a while now, so there is no commit to it.
Hello @toanlc ,
Thanks for the update.
Could you please check whether the task includes other tables, and if any of those tables have undergone significant changes?
Regards,
John.
Hi @john_wang,
I can confirm it's the only table on the parent task.