14 Replies Latest reply: Jun 22, 2018 9:33 AM by reshma k m

# 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?

• ###### Re: Calculate how much RAM needed?

- Marcus

• ###### 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%

• ###### Re: Calculate how much RAM needed?

awesome - thank you!

• ###### Re: Calculate how much RAM needed?

Thanks Tresesco for the explanations and the file

As Thomas said: awesome

Fabrice

• ###### 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

• ###### 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 ...

• ###### Re: Calculate how much RAM needed?

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
• ###### 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?

• ###### 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.

• ###### Re: Calculate how much RAM needed?

So just to totally understand - Then i would need a server with 32Cores but only one license.

And if the server only can have 16 cores - i need 2 servers and 2 licenses right?

• ###### Re: Calculate how much RAM needed?

Yes. But the second option is not necessarily. You can use clustering concept of servers with single license.

Update: Provided that the license is cluster-enabled.

• ###### Re: Calculate how much RAM needed?

Hi,

How can I calculate this for Qlik sense?

• ###### Re: Calculate how much RAM needed?

Doing very much the same. I recommend you to use the Scalability Tools you can find in the Qlik Scalability group to simulate users in your environment and start from that. If the application open without any user connected uses x and with 10 and 20 users uses x * u, it's quite fair to assume that the scaling will be linear.

It's a very accurate way because, after all, your are injecting users -although not real people- in the application, users which are interacting with it.

• ###### Re: Calculate how much RAM needed?

Thanks. I will check it.