# 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

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

- Marcus

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

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

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