Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Is there any way to check memory consumption status for sheet/reports?

Hi,

We have a qlikview node with 386 gb of ram. Sometimes, the ram usage jumps from 60% to 100%. I want to trace exactly which document and which chart cause the whole system to crash.

I tried to look at document analyzer but could not find anything that could help me which object has caused the memory crash at that specific time

Can someone please tell me if there is a way to check the memory usage documentwise or even better if I could have more detail than that for memory consumption?

Shah

5 Replies
MVP & Luminary
MVP & Luminary

Re: Is there any way to check memory consumption status for sheet/reports?

See this blog post: Recipe for a Memory Statistics analysis


talk is cheap, supply exceeds demand
amit_saini
Honored Contributor III

Re: Is there any way to check memory consumption status for sheet/reports?

Hi Syed,

Governance Dashboard can help u.

Data Governance & Data Management with QlikView & QlikView Expressor

Thanks,
AS

rajeshvaswani77
Valued Contributor III

Re: Is there any way to check memory consumption status for sheet/reports?

Hi,

Sometimes shared file corruption causes this.

If you can remove out a shared file you suspect, you may solve this.

This is one of the likely reasons.

Thanks,

Rajesh Vaswani

Highlighted
MVP & Luminary
MVP & Luminary

Re: Is there any way to check memory consumption status for sheet/reports?

Hi Syed,

Open your Dashboard - > Sheet Properties -> Objects -> Check for Calc Time and Memory columns.

Calc Time - Refers to the loading time of the chart and

Memory - Refers to the memory size

This way you can identify which object is taking more time and which object is taking more memory.

Regards,

Jagan.

bouderbc
Contributor

Re: Is there any way to check memory consumption status for sheet/reports?

Hi jagan,

i'm preparing a report to analyze the performance and the weaknesses of a dashboard(qvw) , and i'm using the report generated by Qlik view as you mentioned in your comment using :  Open your Dashboard - > Sheet Properties -> Objects -> Check for Calc Time and Memory columns.

My questions are: 

what is the time measure and meaning of Calc Time and AvgCalcTime ?

How can we know the loading time lapse of a table ?

Thank you