3 Replies Latest reply: Apr 29, 2014 4:59 AM by Suman Dhar

# 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

• ###### Re: Scalability Matrix calculation

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

• ###### Re: Scalability Matrix calculation

Hi,

Please find attached PDF and refer Page 6.

Regards,

Jagan.

• ###### Re: Scalability Matrix calculation

Hi Jagan,

Thanks for your time.

I have the document but somehow I could not understand.

Regards