QlikView RAM usage

[mohamed_ahid]

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

[mukesh24]

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]

Thx for theses explications .

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

[awhitfield]

Hi there,

please see the attached:

[Anonymous]

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]

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]

The memory will be released.

You can see that on Task Manager.

[mohamed_ahid]

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]

The process is not immediate.

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

[#10]

Its released when needed.