Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Please find attached PDF and refer Page 6.
Regards,
Jagan.
Hi Jagan,
Thanks for your time.
I have the document but somehow I could not understand.
Regards