Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
LiemNguyen
Partner - Contributor II
Partner - Contributor II

Configure data loading to utilize RAM instead of CPU

Dear All,
• After Customer upgraded Qlik Sense Client Managed to version May 2023 Patch 3, they found that when loading data it consumed the server's CPU, while RAM usage was minimal. This made it very difficult to control server performance. Please help me check if there is a way to configure data loading to utilize RAM instead of CPU.
• These are 2 pictures of Customer running the same app on 2 servers with almost the same configuration, different Qlik versions.
1. Qlik sense version MAY 2023 patch 3 (ver 14.129.9) - Picture 1
2. Qlik Sense version AUG 2022 (ver 14.78.5)  - Picture 2

Labels (1)
1 Solution
4 Replies
anderseriksson
Partner - Specialist
Partner - Specialist

CPU and RAM are fundamentally different types of resources, one can't simply replace the other.
CPU power is the engine/power driving the load, RAM is storage.
It's like adding a bigger fuel tank to your car to get the engine to rev less?
Helps a little in that you don't have to top up the fuel as many times on a long journey but you still need to use the engine!

Insufficient RAM will lead to higher consumption of CPU as the server needs to move things around
to conserve storage space, but if sufficient RAM is available more will not reduce the need for CPU.
There is no configuration in Qlik Engine to limit the use of CPU, there is a configuration for how much RAM the engine is allowed to use and standard configuration says it should try to hold this between 70~90%.

Comparing two servers at a single point in time is at best indicative but can easily give a false picture.
There are many parameters to consider, number and types of CPUs, size and type of RAM, other loads on the server at that time, active users/connections in Qlik, network, different versions of OS and different versions of Qlik Sense, how long has the server been up and running a.s.o.
To get a better picture you would need to compare the servers over a period of time and after they have been running for some time, a freshly started server will need to do more work as caches are not yet built.
A server that has been running for a long time might instead suffer from left over residue of old processes and memory leaks.

LiemNguyen
Partner - Contributor II
Partner - Contributor II
Author

Hi  Anderseriksson, Thank you very much for your useful information.

LiemNguyen
Partner - Contributor II
Partner - Contributor II
Author

Hi , Thank you very much for your useful information. I will look at the documentation you provided and solve the problem.