Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
toanlc
Contributor II
Contributor II

Unknown latency source

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)

qlik-issue-logs.png

 

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

Labels (1)
4 Replies
Dana_Baldwin
Support
Support

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

toanlc
Contributor II
Contributor II
Author

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.

john_wang
Support
Support

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.

 

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
toanlc
Contributor II
Contributor II
Author

Hi @john_wang,

I can confirm it's the only table on the parent task.