topic Re: Calculate how much RAM needed? in QlikView

Calculate how much RAM needed?

Mon, 26 Jan 2026 18:19:17 GMT

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_sommer — Fri, 24 Jan 2014 09:17:55 GMT

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

- Marcus

Re: Calculate how much RAM needed?

tresB — Fri, 24 Jan 2014 09:28:41 GMT

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?

Fri, 24 Jan 2014 09:36:08 GMT

awesome - thank you!

Re: Calculate how much RAM needed?

Fri, 24 Jan 2014 09:56:04 GMT

Thanks Tresesco for the explanations and the file

As Thomas said: awesome

Fabrice

Re: Calculate how much RAM needed?

Fri, 24 Jan 2014 10:04:47 GMT

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?

tresB — Fri, 24 Jan 2014 10:15:49 GMT

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?

Fri, 24 Jan 2014 10:18:37 GMT

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?

Fri, 24 Jan 2014 10:19:19 GMT

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?

tresB — Fri, 24 Jan 2014 10:30:06 GMT

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?

Fri, 24 Jan 2014 10:31:59 GMT

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?

tresB — Fri, 24 Jan 2014 10:39:25 GMT

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?

reshma_km — Wed, 20 Jun 2018 15:35:59 GMT

Hi,

How can I calculate this for Qlik sense?

Re: Calculate how much RAM needed?

Miguel_Angel_Baeyens — Fri, 22 Jun 2018 06:59:19 GMT

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?

reshma_km — Fri, 22 Jun 2018 13:33:17 GMT

Thanks. I will check it.

Re: Calculate how much RAM needed?

mborsadw — Mon, 11 Feb 2019 14:24:07 GMT

Thanks for this sizing formula. It certainly helps.

In the CPU calculation, there is a line which says "User queries". What is the definition of a query? Are you considering a single SET expression as a query?