topic Re: QLIK SENSE Enterprise low performance on VM in Management & Governance

QLIK SENSE Enterprise has low performance on VM

hillarynyawate — Wed, 02 Nov 2022 06:10:42 GMT

Hi I have installed Qlik sense on a virtual box in a Linux server , but the performance of the dashboards keeps on fluctuating whereby the engine service would stop and even after restarting it, the Utilization of the CPU is consumed to 95% and above. My query is, how would I ensure that I configure qlik sense on a Virtual machine and still use the same server for other activities that will run on linux and maintain a stable Qlik environment?

Re: QLIK SENSE Enterprise low performance on VM

Boris_I — Tue, 31 May 2022 11:55:39 GMT

Hi @hillarynyawate ,

What are the spec of your VM?

You need a minimum of 4 cores and 8 Gb of ram.

https://help.qlik.com/en-US/sense-admin/May2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/Common/system-requirements.htm

Regards

Boris

Re: QLIK SENSE Enterprise low performance on VM

hillarynyawate — Tue, 31 May 2022 13:33:19 GMT

Hi @Boris_I

I use VirtualBox with the following specs:

Total Physical Memory: 111,163 MB
Available Physical Memory: 98,307 MB
Virtual Memory: Max Size: 127,035 MB

Re: QLIK SENSE Enterprise low performance on VM

Boris_I — Tue, 31 May 2022 14:02:45 GMT

Hi @hillarynyawate ,

And many cores are allocated for the Sense server?

Re: QLIK SENSE Enterprise low performance on VM

hillarynyawate — Tue, 31 May 2022 14:05:33 GMT

@Boris_I

Processor(s): 1 Processor(s) Installed.

Re: QLIK SENSE Enterprise low performance on VM

Anders_Eriksson — Tue, 31 May 2022 14:11:24 GMT

Hint: 1 processor and your CPU consumption is at 95%, you need at least 4 cores

Re: QLIK SENSE Enterprise low performance on VM

hillarynyawate — Tue, 31 May 2022 14:11:59 GMT

Its also using a hypervisor

Re: QLIK SENSE Enterprise low performance on VM

Anders_Eriksson — Tue, 31 May 2022 14:14:20 GMT

Especially if you are thinking of running other things on the same server.
CPU starvation is almost a given if you only have one CPU.
You need to account for all CPU and memory loads on all virtual machines on that Linux box.
Idealy Qlik should have dedicated resources.

Re: QLIK SENSE Enterprise low performance on VM

hillarynyawate — Tue, 31 May 2022 14:19:21 GMT

what if I need to share the same server with other platforms like Databses, whats the ideal solution, should more resources be assigned to the Virtual box? and what would be the max recommended?

Re: QLIK SENSE Enterprise low performance on VM

Anders_Eriksson — Wed, 02 Nov 2022 06:09:56 GMT

Firstly Qlik Sense is only supported on windows. Here is Qlik Sense System Requirement.

Secondly, Qlik Sense engine tends to be hungry for CPU & memory. It is always the supported and best practice to have dedicated server for Qlik Sense. Combining them on shared resources can be a bad thing but it could also work. It all depends on how much resources you have and they (database & Qlik) need simultaneously.
Shared resources dynamically allocated sounds great but is not if both systems need the resources at the same time.

But PROD should only has dedicated server.

Re: QLIK SENSE Enterprise low performance on VM

Boris_I — Tue, 31 May 2022 15:25:43 GMT

if you plan to have multiple platforms on your linux server ,make sure to check the requirement for each of them including the operating system.

Each platform should have it own dedicated processor/core and ram

Re: QLIK SENSE Enterprise low performance on VM

Eduardo_Monteiro — Wed, 01 Jun 2022 02:34:23 GMT

Hello @hillarynyawate

Make sure you also check the engine service memory threshold. See the link below: Qlik Sense Engine - How the memory hard max limit ... - Qlik Community - 1717228

In the link below you can also check a list of requirements to run a healthy Qlik Sense Server.

System requirements for Qlik Sense Enterprise ‒ Qlik Sense for administrators

Regards,

Eduardo Monteiro

Re: QLIK SENSE Enterprise low performance on VM

hillarynyawate — Mon, 06 Jun 2022 09:04:11 GMT

@Anders_Eriksson

Well then does this means that now Qlik has to be on in its own server for optimal performance and scalability?

Re: QLIK SENSE Enterprise low performance on VM

hillarynyawate — Mon, 06 Jun 2022 09:21:38 GMT

Ok understood, thanks for the insight @Anders_Eriksson

Re: QLIK SENSE Enterprise low performance on VM

Anders_Eriksson — Mon, 04 Jul 2022 14:29:55 GMT

Sorry for a late answer, been very busy last weeks.
Yes own server has always been the optimal for performance and scalability.
It is for every program, even "MS Mines".
Kidding aside shared servers can work but then need to be dimensioned for the shared peek load.
Databases and Qlik (which is an in memory database essentially) both need memory.
When replying to a question both databases and Qlik needs CPU.
If these things happen in parallel you are going to run out of resources.

Re: QLIK SENSE Enterprise low performance on VM

Eugene_Sleator — Tue, 05 Jul 2022 15:04:16 GMT

Hi @hillarynyawate you really should review this document for a clear description of memory and CPU usage

The Qlik Associative Engine memory management and CPU usage

And this article for best practices when deploying to a virtualized environment

Virtualization-Best-Practices-In-QlikView-And-Qlik-Sense

hope this helps