topic Re: Slow Performance to open sheets and calculate in Management & Governance

Slow Performance to open sheets and calculate

KefangWorker — Tue, 01 Jun 2021 13:41:09 GMT

Hi,

we have installed the Qlik Sense Enterprise. Currently, it experiences the issues of slow performance. The sheets and calculation are hard to complete. Besides that we have found out the very high CPU and Memory consumption by Qlik Sense, even if there is no such calculation during the night.

I have tried the methods mentioned here to improve.

However, it didn't help out.

Now, I'd like to know the following:

1. The reasons behind slow performance.

2. How to find the reasons and how to fix this issue.

Thanks a lot.

Kefang

Re: Slow Performance to open sheets and calculate

PadmaPriya — Tue, 01 Jun 2021 14:44:51 GMT

Hello @KefangWorker

Please see the following Article with PDF attachment that explains in much greater detail how the working set limits and CPU utilization occur in the QIX Engine:

How much RAM is consumed per application

QIX Engine Memory Management and CPU Utilization

Thanks,

Padma Priya

Re: Slow Performance to open sheets and calculate

rwunderlich — Tue, 01 Jun 2021 16:18:27 GMT

There are a number of reasons why an application runs slow. The first thing I would recommend is to identify if the performance is an app wide problem or if specific charts are causing the issue. I recommend you analyze the app with QSDA and sort the calc times on the Viz sheet in the analysis results.

-Rob

Re: Slow Performance to open sheets and calculate

nirav_bhimani — Thu, 06 Mar 2025 10:53:25 GMT

Hi,

In Telemetry & Performance Monitoring (TPM) you can get insights on Resource Optimization. This allowed the IT team to Pinpoint Performance Bottlenecks as they occurred.

Identify memory-hungry apps that may impact overall system performance. It empowers to optimize app performance, ensuring a seamless user experience.

You can get insight on which App objects consuming more resources like CPU/RAM.

Following are some important links.

TPM Introduction Video

TPM Blog

Test Drive for Trial: Check out TPM

Wiki

Regards,

Nirav