topic Re: Document analyzer issue in QlikView

Document analyzer issue

mayankraoka — Thu, 01 Sep 2016 16:07:01 GMT

Hi all,

I am analyzing my data volume and its behavior on user experience while accessing document from access point.

Lets assume that my data file is of size 1GB and application qvw size is 36mb. But in Document Analyzer ->Summary sheet->Ram Foot print is 123 MB

What is this Ram footprint means here?

How many concurrent users can access the app from access point ?

Ram size is 128gb

Regards,

Mayank

Re: Document analyzer issue

Anil_Babu_Samineni — Thu, 01 Sep 2016 16:19:37 GMT

Have you observe here

Qlikview server sizing

Because, It's the amount of system RAM that Qlikview will use It's called Ram Footprint

How to calculate that, So refer the link

Re: Document analyzer issue

rwunderlich — Fri, 02 Sep 2016 10:16:11 GMT

qvw file size is typically smaller than actual ram required, because the qvw is by default stored compressed (can be changed on the Document Properties, General tab).

Document Analyzer (DA) "RAM Footprint" is the amount of memory required to load up the document for a single user. It includes:

1. The uncompressed data model (tables and fields).

2. The Selection & State tables for one user.

3. The RAM required to calculate all sheet objects. Admittedly, this figure is high for a single user, because one user would typically not calculate all objects at once. But several users might.

The amount of RAM for each additional user can be found on the DA Memory sheet in the "Per User Memory" box.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Document analyzer issue

mayankraoka — Sat, 03 Sep 2016 13:56:05 GMT

Hi Rob,

Thank you for your explanation.

Just to be bit clear.If DA says Ram footprint is 80MB and Per user memory is 8mb.So is it right to say...If 10 concurrent users will consume 80+8*9(72)=152MB RAM required?

Regards,

Mayank

Re: Document analyzer issue

rwunderlich — Sat, 03 Sep 2016 15:21:41 GMT

Hi Mayank,

Yes, I would agree your formula is correct.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Document analyzer issue

mayankraoka — Sat, 03 Sep 2016 18:30:53 GMT

Thank you very much Rob...