Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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%

View solution in original post

15 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

tresesco
MVP
MVP

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%

View solution in original post

Not applicable
Author

awesome - thank you!

Not applicable
Author

Thanks Tresesco for the explanations and the file

As Thomas said: awesome

Fabrice

Not applicable
Author

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

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
Author

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
Author

So if my Demand is 8000 CPU seconds

And one 8-QuadCore delivers 1920 CPU seconds

Dont i need 4*1920 then?

tresesco
MVP
MVP

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.