Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

Calculate how much RAM needed?

Hello,

I wanna know how to calculate how much ram there is needed for our setup?

Lets take an example:

SourceData 50GB

No. Concurrent users 200

How do you calculate approx how much ram the server needs?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Calculate how much RAM needed?

Aproximately 900 GB

PFA

Update:

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%

14 Replies

Re: Calculate how much RAM needed?

MVP
MVP

Re: Calculate how much RAM needed?

Aproximately 900 GB

PFA

Update:

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%

Not applicable

Re: Calculate how much RAM needed?

awesome - thank you!

Not applicable

Re: Calculate how much RAM needed?

Thanks Tresesco for the explanations and the file

As Thomas said: awesome

Fabrice

Not applicable

Re: Calculate how much RAM needed?

tresecso - Does that means i need 4 enterprise servers? And 4 licenses? That will be around 200.000 (Enterprise server license i DKK) * 4

MVP
MVP

Re: Calculate how much RAM needed?

Certainly not !

I guess you are talking about CPU core. Options there are in 'OR' mode. If you have dual core or quad core ...

Not applicable

Re: Calculate how much RAM needed?

I dont get it?

My demand says

CPU SizingTotal in GB
Numer of simultaneous Users60
User queries2Each user fires a query at 2 times a Minute on Average
CPU Seconds67Double the Qvw in RAM
Demand8000Total CPU Seconds
Deployment ChoicesInput # BoxesTotal CPU SecondsChoose which one best suites your deployment
8-QuadCore or11920- a server with 8 quad cores (32 CPU kernels) provides  32 * 60 CPU = 1920 seconds per minute
4-QuadCore or1960- a server with 4 quad cores (16 CPU kernels) provides  16 * 60 CPU = 960  seconds per minute 
2-QuadCore1480- a server with 2 quad cores (  8 CPU kernels) provides    8 * 60 CPU  = 480  seconds per minute
Not applicable

Re: Calculate how much RAM needed?

So if my Demand is 8000 CPU seconds

And one 8-QuadCore delivers 1920 CPU seconds

Dont i need 4*1920 then?

MVP
MVP

Re: Calculate how much RAM needed?

Right. But it is related to cores; not the licenses. You have to increase the hardware capacity (32-core CPU + server). That is what it tells about.

Community Browser