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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mayankraoka
Specialist
Specialist

Document analyzer issue

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

5 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

mayankraoka
Specialist
Specialist
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Mayank,

Yes, I would agree your formula is correct.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

mayankraoka
Specialist
Specialist
Author

Thank you very much Rob...