topic Re: Limit the amount of RAM QlikView Server uses in QlikView

Limit the amount of RAM QlikView Server uses

paulm — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I was wondering if I can limit the amount of RAM that QlikView Server uses? I have limited the working set which I thought it would have limited it but it still seems to use all of the memory available.

Currently using 10SR3

Thanks
Paul

Re: Limit the amount of RAM QlikView Server uses

Fri, 26 Apr 2013 06:44:40 GMT

,Hi

Instead of Limiting the RAM on Server , try to limit the Data that are going to be loaded.

Try to load only few quarters data instead of entire Quarters Data .

//Yusuf

Re: Limit the amount of RAM QlikView Server uses

Bill_Britt — Fri, 26 Apr 2013 12:49:17 GMT

Hi Paul,

Not sure why you would want to do this. This would just cause performance issues for the users.

Bill

Re: Limit the amount of RAM QlikView Server uses

paulm — Fri, 26 Apr 2013 13:01:23 GMT

HI Bill,

We have two applications on the server at present. QlikView has a habit of using all the RAM and in turn crashing the other non qlikview application. So yes I agree its obviously better to let QlikView use as much as it likes, I need to leave about 20% free for the other application.

Thanks
Paul

Re: Limit the amount of RAM QlikView Server uses

Bill_Britt — Fri, 26 Apr 2013 14:45:50 GMT

Hi,

This is never advisable to run other non-qlikview applications on the same server as QlikView. QlikView is an in-memory analysis technology; memory requirements for QlikView products are directly related to the quantity of data being analyzed. I would recommend you move the other application to another server.

Bill

Re: Limit the amount of RAM QlikView Server uses

paulm — Fri, 26 Apr 2013 14:51:40 GMT

Hi,

The other application is part of a solution that makes use our QlikView solution. The cost of separation of the solution is quite sufficient for us, so we hoped to increase the RAM and number of CPU's, then limit how much QlikView can use of it.

Is it right to assume that there is no way of limiting the amount of RAM QlikView can use then?

Thanks
Paul

Re: Limit the amount of RAM QlikView Server uses

Bill_Britt — Fri, 26 Apr 2013 15:02:57 GMT

Hi Paul,

No, there is no way to tell QVS to use only XX amount of memory.

Bill

Re: Limit the amount of RAM QlikView Server uses

paulm — Fri, 26 Apr 2013 15:04:43 GMT

Cheers Bill. Thanks for your help.

Re: Limit the amount of RAM QlikView Server uses

Fri, 26 Apr 2013 15:57:57 GMT

Hi Bill,

It was a good Discussion going on.

Just need a help.

I seen couple of Videos do decide how exactly to determine the RAM size if we knew the Data Volume size

but i didn't got that much information .

If we consider only one User .

Do you know any Material or QlikView stuff which says that for this much amount of Data Volume you need to have 'X' GB size of RAM.

//Yusuf

Re: Limit the amount of RAM QlikView Server uses

Bill_Britt — Fri, 26 Apr 2013 18:52:33 GMT

There was an old rule of thumb, that if you look at the size of the unopen document in properties you can figure it.

Lets say the QVW is 100mb and we will have 10 users

100mb * 4 = 400mb to open document on server.

Each additional user adds 10%

10 user at 10% would be another 400mb

So to maintain the basic document with 10 users would be around 800mb.

Note: This does include the memory used as spikes as the users Qlick around in the document.

Bill

Re: Limit the amount of RAM QlikView Server uses

Tue, 30 Apr 2013 13:50:13 GMT

Based on this old rule of thumb, if I have a document which takes 20GB of RAM, then for 100 users I will need

20 + 0.1*20*100 = 220GB

which I think is a bit exagerrated.

From what I've noticed, only the first few users might use 10% of the document size, with the following users using less and less.

For example:

- First 10 users:

20 + 0.1*20*10 = 40GB

- First 30 users:

40 + 0.05*20*20 = 60GB

- First 60 users:

60 + 0.03*20*30 = 78GB

- First 100 users

78 + 0.01*20*40 = 86GB

I am curious to see what other people have experienced.

Re: Limit the amount of RAM QlikView Server uses

Bill_Britt — Tue, 30 Apr 2013 14:03:20 GMT

Hi,

Remember I said the old rule of thumb. This was from about 7 years ago. I am sure we have made progress with this over the years.

Bill

Re: Limit the amount of RAM QlikView Server uses

Tue, 30 Apr 2013 16:47:00 GMT

Hi ,

One more thing ,As we know that the Processor can help in Processing the Data fast (similar to RAM) so just wanted to know Do you think if there is any way that the Processor can play any role in the RAM memory usage means making the Usage to limit .

Can i use Processor as alternate option to RAM ?

If "YES" then is there any equation ot determine how many core( means dual core, quad core and so on) is equivalent to "X" size of RAM ?

//Yusuf

Re: Limit the amount of RAM QlikView Server uses

manojkvrajan — Thu, 02 May 2013 11:30:09 GMT

Yusuf

To get more int the Technical details - Processors may not be viable solution for your environment. Processors are used for computation of your expressions in your charts (or any QlikView object). RAM is to stack up the data based on your selections. RAM + Processors are the best solution and equation can be determined based on the Data size, No. of applications, Application and Architecture standards, No. of users and Network Bandwidth (Or connectivity) in your environment. Please remember Hardware spending may not be a solution. It is good to consider software configuration (QEMC) and Application Architecture inlcuding data model and scripting before spending any money on infrastructure

Bill made a good point. In addition, checking 'Allow Only One Copy of Document in Memory' settings in QEMC will let you to use limited RAM size close to actual size of the Application. Memory won't shoot up drastically when concurrent users use the application as selections are made on the preloaded application (qvw). However CPU may spike based on the computation / calculation time of your expressions and data model.

Re: Limit the amount of RAM QlikView Server uses

Tue, 30 Jul 2013 03:08:48 GMT

Hi,

One of my documents has started using an extreme amount of RAM and I can't figure out why.

The document is about 250Mb and with one user logged onto it the server RAM usage suddenly spirals up to 90gb and results in a "No connection" error. The server is ONLY used for qlikview. Any ideas what this could be?

Cheers,

Re: Limit the amount of RAM QlikView Server uses

ramasaisaksoft — Mon, 11 May 2015 10:01:43 GMT

Hi Bill,

For my curia city, can you please show me the below statement in qlikview help guide?or Qlikview books please....

This is never advisable to run other non-qlikview applications on the same server as QlikView.