Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Scalability Matrix calculation

We have 32GB RAM and approx average 100 mb size of application.
Average application count is 80. Concurrent users-30 and currently cpu utilization 40%.
we have 300 license on the server we want to increase 100 more.We are using QV 10.

I have gone through the scalability matrix but not understood the below formula.

It will be great if anyone help me abot this.


RAM = (RAMuser × No. users) + RAMinitial
Where
RAM〗initial = QVWsizedisk × FileSizeMultiplier; this is the initial RAM footprint for any application
RAM〗user =〖RAMinitial × userRAMratio; this is the RAM each incremental user consumes
QVWsizedisk = SourceData × (1 - CompressionRatio); this is the size, on disk, of a
QlikView file


3 Replies
Clint_Carr
Employee
Employee

Hi Suman,

The RAM footprint is typically calculated as:

1. Source Data Size on Disk is compressed approximately 90%.

2. When the application is loaded into RAM as a QVW the size expands ~4 times

3. Each subsequent user typically adds ~2 - 5% of the inital load (discovered in step 3).  This amount changes based upon usage of the application, more caching reduces size.

So if we have 1000Mb (1Gb) of source data we can predict the size of the QVW file will be ~100Mb.


If this application is loaded into RAM we can expect ~400Mb of RAM being used.

Each additional user will then add 2-5% so 8 - 20Mb of RAM.


So total RAM used = (Initial Load) + ((RAM Per User)*Concurrent Users)

The above can fluctuate up or down depending on cardinality of the data.

Clint

jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached PDF and refer Page 6.

Regards,

Jagan.

Anonymous
Not applicable
Author

Hi Jagan,

Thanks for your time.

I have the document but somehow I could not understand.

Regards