Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

agni_gold
Valued Contributor

RAM Usage

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:

4 Replies
Highlighted

Re: RAM Usage

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

agni_gold
Valued Contributor

Re: RAM Usage

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

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

-Rob

thornofcrowns
Valued Contributor II

Re: RAM Usage

ANother thing I learned today, thanks!