topic Re: RAM & CPU in the system in QlikView

RAM & CPU in the system

bharath28 — Tue, 04 Mar 2014 15:47:40 GMT

Hi,

We are going to Install Qlikview Small Business Edition and I need to provide RAM & CPU needed to the admin team.

We have maximum 10 users and less than 10 Qlikview applications and the maximum size of the qvw is approx. 500 MB.

I have come across few formulas to calculate the RAM, however I request some one to suggest me the RAM & CPU that we can be step up in the system based on the above requirement.

Regards,

Bharath

Re: RAM & CPU in the system

MK_QSL — Tue, 04 Mar 2014 15:57:14 GMT

analyze the RAM and CPU usage

Re: RAM & CPU in the system

Tue, 04 Mar 2014 16:08:32 GMT

The number of users is less important than the number of concurrent users.

if you have 10 applications, and 10 concurrent users, one possibility is that each user works on his/her own application.

A good formula is (per application):

4 x Size of the QVW

Nb of concurrent users x Size of the QVW

So for example, your "big" application of 500 Mb: 2 Go + 5 x 500 Mb if you may have up to 5 concurrent users on that application

If you think that all users may work on their own application, sum up the size of all the applications and multiply that number by 4.

Fabrice

Re: RAM & CPU in the system

vikasmahajan — Tue, 04 Mar 2014 16:14:05 GMT

Please Find attached File.

vikas

Re: RAM & CPU in the system

bharath28 — Tue, 04 Mar 2014 16:41:56 GMT

Hi Fabrice,

Thanks for your inputs. I have difficulty understanding your example. Could you please tell mewhat is '2 Go' ?

Regards,

Bharath

Re: RAM & CPU in the system

Tue, 04 Mar 2014 19:54:11 GMT

Go is french word for Gb (like Mo for Mb)

Fabrice

Re: RAM & CPU in the system

maxgro — Tue, 04 Mar 2014 20:40:31 GMT

There are some good guidelines, I think you already know them from previous suggestions and attachment

I usually start on my pc checking RAM and CPU of the single qvw I have to deploy (when possible but I tkink you can as your qvw are 500 mb) and than follow the guidelines (add RAM for concurrent users of every qvw, sum up the RAM of single qvw taking into account how many will be used at the same time)

Re: RAM & CPU in the system

bharath28 — Thu, 06 Mar 2014 09:09:33 GMT

Thanks for all the suggestions.

I am now working on the disk space to install the Qlikview server. The minimum required space is 1 GB to install the Qlikview server as per System requirement document.

However Please suggest, what could be the disk space that is best for my requirement(Please check my original question).

I assume that the disk space required is only to store the qlikview applications, qlikview server, logs etc.. So, shall I go for around 5 GB?

Thanks !!

Regards,

Bharath

Re: RAM & CPU in the system

bharath28 — Thu, 06 Mar 2014 14:31:15 GMT

Hi Guys..any input for this one pls.

Re: RAM & CPU in the system

Ricardo_Gerhard — Thu, 06 Mar 2014 14:53:22 GMT

Simulation with compress ratio 10%, 10 users simultaneous and 5 app with 500mb each

App Memory

5 app x 500 mb =

2500 * 10 ratio =

25000 of RAM to applications

User Memory

10 users * (10% ratio of 25000) =

10 * (2500) =

25000 of user session memory

Total of memory = 50GB

Re: RAM & CPU in the system

Thu, 06 Mar 2014 14:53:35 GMT

It is recommended to install QV alone on one server, because QV is very intensive (it will use 100% of CPU during a short moment per user). This 100% use of CPU is, of course, multiplied by the number of requests (depending on user activity and the number of users). Same with memory where QV tends to take all the available memory (there are parameters for min/max but I do not know them)

If you share QV with another software (like SQL or whatever), it may hurt these softwares, or QV (because you will restrict memory max)

Hence, if QV is alone, disk space is not a problem.

In all cases, disk space should not be a problem

Fabrice