Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

QlikView CPU Core 100% utilization (few core)

Hi, I have noticed on many occasions that there are random peaking of CORE's we have setup for our QlikView environment. There are 40 cores out of which at any given time 10 Core's are usually peaking at flat 100%. This keeps changing and even when the CPU is not 100% overall, these core CPU's still consume 100%.

CPU Utilisation.JPG

CPU Utilisation(1).JPG

CPU Utilisation(2).JPG

Has any one noticed such kind of CPU utilization. We have capacity of running max 30 tasks at any given time. We notice lot of tasks getting in queue and it could be due to server load. Can some one please guide.

1 Solution

Accepted Solutions
Highlighted

Re: QlikView CPU Core 100% utilization (few core)

In QlikView 12.20, Distribution Service by design uses much more resources than early 12.00 and 11.20. In our case we had to move from 15 concurrent to 6 concurrent, otherwise the server crashed. We checked other alternatives with Qlik Support and there were none.

The "queue" was introduced at the same time than this new consumptions, so tasks are indeed triggered, but they don't start running until either CPU is below certain threshold or RAM consumption is. This threshold can be set up in the file QVDistributionService.exe.config modifying the keys CpuOverloadLimit and MemoryOverloadLimit. These settings apply to the whole server, not per CPU.

So what you see is completely normal and expected, but make sure you have at least one idling core to take care of other activities in the computer (OS, backup, antivirus, remote desktop) or you will end up with an unresponsive server.

View solution in original post

3 Replies
Highlighted
New Contributor III

Re: QlikView CPU Core 100% utilization (few core)

Anyone facing similar issue?

Highlighted
Valued Contributor II

Re: QlikView CPU Core 100% utilization (few core)

Looks like those are four CPUs with 8 cores each. IIRC, multi-thread QlikView reloads can use all of the CPUs in some contexts, but in most, they will use all of the cores on one CPU and none of the others. I would guess you are experiencing the latter - one of your tasks is eating up 100% of one full CPU.

Highlighted

Re: QlikView CPU Core 100% utilization (few core)

In QlikView 12.20, Distribution Service by design uses much more resources than early 12.00 and 11.20. In our case we had to move from 15 concurrent to 6 concurrent, otherwise the server crashed. We checked other alternatives with Qlik Support and there were none.

The "queue" was introduced at the same time than this new consumptions, so tasks are indeed triggered, but they don't start running until either CPU is below certain threshold or RAM consumption is. This threshold can be set up in the file QVDistributionService.exe.config modifying the keys CpuOverloadLimit and MemoryOverloadLimit. These settings apply to the whole server, not per CPU.

So what you see is completely normal and expected, but make sure you have at least one idling core to take care of other activities in the computer (OS, backup, antivirus, remote desktop) or you will end up with an unresponsive server.

View solution in original post