topic Re: Qlik Sense Server: RAM usage in Management & Governance

Qlik Sense Server: RAM usage

vicio — Sat, 20 May 2017 09:46:19 GMT

I'm running Qlik Sense Server on a Windows R2016 Server with 256GB of RAM.

But it seems that Qik Server Services are not going over 30GB (12% usage).

There is some configuration to use all the RAM and get some performance increment?

Thanks

Vicio

Re: Qlik Sense Server: RAM usage

barry_stevens — Sun, 21 May 2017 23:28:29 GMT

May seem like a silly question but are you loading data larger than 30GB?

Re: Qlik Sense Server: RAM usage

vicio — Sun, 21 May 2017 23:46:51 GMT

Thanks.

Btw, I checked, and it's about 80GB.

And in fact, it could be possible that with compression and encoding, the core data in the memory of Qlik Sense is just 30GB.

I accept your answer as correct because it just makes sense considering the RAM issue.

But I have 256 Core, 256GB of RAM, 20GB of network speed and in some Sheet, I still wait for a few seconds to rebuild the chart, after the selection.

I'm using EC2 a m4.16xlarge, I'm still figuring out what is the best solution to speed up Qlik Sense Server.

I have a demo with my best client in a couple of hours and I could boost the server.

What I could increase or optimize to get more speed. I'm on AWS so that I can change configuration with a restart (a few minutes).

Re: Qlik Sense Server: RAM usage

barry_stevens — Sun, 21 May 2017 23:55:08 GMT

Is this 'delay of a few seconds' seen on a browser running on the server or from an external machine connecting to the instance?

Re: Qlik Sense Server: RAM usage

vicio — Mon, 22 May 2017 02:38:28 GMT

From External machine or internal machine is the same.

I'm connecting with a 100Mbs fiber to the server.

I can see the loading icon spinning for a few seconds (5-20secs).

I noticed that is happening the first time, I enter a sheet. If I go back/forward and step back the is loading immediately (cache effect). But if I close and re-open the browser, I can still see the effect of the cache: a page loaded before pops up quickly. So I assume that the cache is on server side.

Re: Qlik Sense Server: RAM usage

vicio — Sat, 27 May 2017 05:06:37 GMT

Hi barry.stevens‌,

On Saturday maintenance windows:

I made QSE swallow 500GB of raw data from RedShift.

QSE is using all the available RAM now.

It's impressive the efficiency of Qlik to squeeze data in RAM.

I noticed that with large dataset the waiting for Data loading is increasing. I clicked in Data Manager and more than 10 minutes to just get the tables list. I will study to optimize this, at least, I will open a new thread.

Thanks again.

Vicio

Re: Qlik Sense Server: RAM usage

perumal_41 — Mon, 07 Jan 2019 09:00:26 GMT

Dear Vicio,

I am facing the same problem in one my client.

can we know what is the step taken for sorting out the issue?.

So We can try the same step in our environment also.

Thanks ,

Perumal A