Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohamed_ahid
Partner - Specialist
Partner - Specialist

QlikView RAM usage

Hi all,

can anyone explain me how qlikview server use the memory when we have severals applications and many user .

Simple Senario :

i have one application with 8GO of size deployed on my server (96 RAM 6 cores ).beside i have 40 users who can acces this application .Let's imagine thats user 1 connect to server .How the mermory is used int his case ?

After deconnecting from the server how the mermory is used also in this case ?

in the case of many users in the same time .how it works ?

how works sign in sign out ?

Thx lot

9 Replies
mukesh24
Partner - Creator III
Partner - Creator III

Hi,

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

Assumptions:

userRAMratio: range between 1%–10%

FileSizeMultiplier: range between 2–10

CompressionRatio: range between 20%–90%



mohamed_ahid
Partner - Specialist
Partner - Specialist
Author

Thx for theses explications .

what do you mean by FileSizeMultiplier ? and how we calculate it ?

awhitfield
Partner - Champion
Partner - Champion

Hi there,

please see the attached:

Anonymous
Not applicable

correct.

"For example: A 1GB .qvw document uses around 4GB in RAM for the first user (based on a multiplier of 4x to establish the initial RAM footprint based on file size). This multiplier is normally between 2x and 10x. User number two may increase this by around 10% as their calculations get cached resulting in a required RAM footprint of 4.4GB. User number 3 requires a further 10%, increasing the footprint to 4.8GB, and so on...."

mohamed_ahid
Partner - Specialist
Partner - Specialist
Author

thx.

suppose that we have 4.8gb allocted for our application (4 gb of size + 3 user ).

what happened when all the user sign out ?

Anonymous
Not applicable

The memory will be released.

You can see that on Task Manager.

mohamed_ahid
Partner - Specialist
Partner - Specialist
Author

i'v checked it out ,it's not released .

Are you sure about that ?

Because i'v seen on one of my last project , on the server it was required to have   drain down's batch running on .

Anonymous
Not applicable

The process is not immediate.

works like System.GC on C# or System.gc() on java.

Not applicable

Its released when needed.