Calculate how much RAM needed?

[#1]

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?

[marcus_sommer]

Look here: http://community.qlik.com/search.jspa?q=RAM%2C+CPU

- Marcus

[tresesco · Accepted solution]

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%

[#4]

awesome - thank you!

[#5]

Thanks Tresesco for the explanations and the file

As Thomas said: awesome

Fabrice

[#6]

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

[tresesco]

Certainly not !

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

[#8]

I dont get it?

My demand says

CPU Sizing	Total in GB
Numer of simultaneous Users	60
User queries	2	Each user fires a query at 2 times a Minute on Average
CPU Seconds	67	Double the Qvw in RAM
Demand	8000	Total CPU Seconds
Deployment Choices	Input # Boxes	Total CPU Seconds	Choose which one best suites your deployment
8-QuadCore or	1	1920	- a server with 8 quad cores (32 CPU kernels) provides  32 * 60 CPU = 1920 seconds per minute
4-QuadCore or	1	960	- a server with 4 quad cores (16 CPU kernels) provides  16 * 60 CPU = 960  seconds per minute
2-QuadCore	1	480	- a server with 2 quad cores (  8 CPU kernels) provides    8 * 60 CPU  = 480  seconds per minute

[#9]

So if my Demand is 8000 CPU seconds

And one 8-QuadCore delivers 1920 CPU seconds

Dont i need 4*1920 then?

[tresesco]

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.