topic RAM Usage in QlikView

RAM Usage

agni_gold — Fri, 28 Mar 2014 04:57:23 GMT

I want to build a dashboard which contains charts which will show following:

1.cpu uasge

2.ram usage

Suppose I have a qvd having size of 2gb.then how can I calculate ram uasge and show it in my chart.

i have found a calculation

Ram=(Ramuser × No. users) + RAMinitial

RAMinitial = QVWsizedisk × FileSizeMultiplier; this is the initial RAM footprint for any application

RAMuser =〖RAMinitial × userRAMratio; this is the RAM each incremental user consumes

= SourceData × (1 - CompressionRatio); this is the size, on disk, of a QlikView file

but I don't know I can find all these values:

Re: RAM Usage

rwunderlich — Fri, 28 Mar 2014 05:05:02 GMT

You can create a mem file to get the actual numbers. In Document Properties, General, press the Memory Statistics button. You can process the mem file yourself or use something like QvOptimizer to analyze it. There is a copy in this thread.

Re: Virtual Out Of Memory Error While Saving the Document

-Rob

Re: RAM Usage

agni_gold — Fri, 28 Mar 2014 06:21:48 GMT

Hi Rob,

I got the memory files but when I am trying to load it I am not able to do so,as well as I am not able to understand the data within that mem file

Re: RAM Usage

rwunderlich — Fri, 28 Mar 2014 14:52:46 GMT

Try the QvOptimizer/qvw I referenced above. It provides script to load the mem file and interpret the results.

-Rob

Re: RAM Usage

ThornOfCrowns — Fri, 28 Mar 2014 15:41:05 GMT

ANother thing I learned today, thanks!