Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
zhadrakas
Specialist II
Specialist II

Limit CPU Cores for Publisher .exe

Hello,

i want to know if there is a way to limit the use CPU cores for the publisher .exe files.

After migrating to Qliview 12.3 the publisher uses much more CPU than before.

in some time ranges Publisher takes 90-100% of the CPU. That leads to Performance degrade on users site.

My wish would be to say that next two files can only use 60% of the CPU cores.

  • QVDistribution.exe
  • qvb.exe

Thanks for any help 

regards

tim

 

Labels (2)
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

The only way to impact things is via the following two settings in the 12.30 and later tracks:

<!-- If the CPU usage % goes above this value the machine is considered overloaded and no new tasks will be started. -->
<add key="CpuOverloadLimit" value="75"/>
<!-- If the memory usage % goes above this value the machine is considered overloaded and no new tasks will be started. -->
<add key="MemoryOverloadLimit" value="90"/>

This is really only going to impact whether a task is able to start though, but that might have a positive impact as if you are running too many concurrent tasks, that is likely the real culprit.  I would venture the correct solution though is to use a separate server for the Publisher services, this way you do not impact the QVS and the user experience...  A virtual machine with the correct resources allocated where the host machine is not oversubscribed would work well for Publisher, it would not necessarily need to be a physical server.  About the best guidance I can give you.

Here is a link to a doc the engineers put together last year on scaling Publisher too:

Scaling QlikView Publisher 

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

1 Reply
Brett_Bleess
Former Employee
Former Employee

The only way to impact things is via the following two settings in the 12.30 and later tracks:

<!-- If the CPU usage % goes above this value the machine is considered overloaded and no new tasks will be started. -->
<add key="CpuOverloadLimit" value="75"/>
<!-- If the memory usage % goes above this value the machine is considered overloaded and no new tasks will be started. -->
<add key="MemoryOverloadLimit" value="90"/>

This is really only going to impact whether a task is able to start though, but that might have a positive impact as if you are running too many concurrent tasks, that is likely the real culprit.  I would venture the correct solution though is to use a separate server for the Publisher services, this way you do not impact the QVS and the user experience...  A virtual machine with the correct resources allocated where the host machine is not oversubscribed would work well for Publisher, it would not necessarily need to be a physical server.  About the best guidance I can give you.

Here is a link to a doc the engineers put together last year on scaling Publisher too:

Scaling QlikView Publisher 

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.