Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Contact
Find Answers
Join Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support knowledge database or request assisted support for your highly complex issues.
Submit a Case
Talk with a Representative
Critical Issues
Experiencing a serious product issue? Please Contact us by phone. Click here to view phone numbers and hours by region.
Contact UsWelcome Guest
Installed Qlik Products
My Environments
Log your environments to ensure faster and more targeted troubleshooting.
View Available Licenses
My Licenses
Understand your licenses to help you maximize your experience.
Knowledge
QlikView Distribution Service / Publisher (QDS) high CPU usage without active tasks
Article Number: 000054966 | Last Modified: 2018/11/01Description
The QlikView Distribution Service (QDS) is consuming a high percentage of overall CPU capacity. No tasks are actively running.
Environment:
Environment:
QlikView 12.20 (November 2017)
Cause
All tasks will be checked no matter if they are enabled or disabled every 500ms in general, the auto adjustment option is not working good when a large number of tasks are disabled or not properly setup.
Risks for high cpu usage are caused by:
- large number of disabled tasks,
- enabled tasks but no source document connected to it.
- a fresh QVPR restore, but unfinished setup
Risks for high cpu usage are caused by:
- large number of disabled tasks,
- enabled tasks but no source document connected to it.
- a fresh QVPR restore, but unfinished setup
Resolution
Task files need to be updated regularly. It is possible to adjust the number of tasks updated per thread.
Change the value to 1000, which is 1 sec, do not use a higher value than that.
- Stop the QlikView Distribution Service
- Navigate to C:\Program Files\QlikView\Distribution Service\DistributionService.exe.config
- Open the file in a text editor with elevated permissions.
- Option 1: Locate the below setting, or add it:
<!-- Time to pause between task result cache updates, in milliseconds. -->
<add key="TaskResultCacheUpdateSleepTimeBetweenUpdates" value="200"/>
Change the value to 1000, which is 1 sec, do not use a higher value than that.
- Option 2 (if the first one does not show results):
<!-- Max number of tasks per thread updating the task result cache. Value less than one (1) enabled automatic calibration. -->
<add key="TaskResultCacheUpdateMaxTasksPerThread" value="0"/>
Raise the value to lower the baseline QDS CPU consumption. A starting value can be a slightly higher number than the total number of tasks in the deployment.
To get the total of your tasks you can use the QVPR Analyser: https://community.qlik.com/docs/DOC-5892 Note that this tool is not a supported tool by Qlik.
<add key="TaskResultCacheUpdateMaxTasksPerThread" value="0"/>
Raise the value to lower the baseline QDS CPU consumption. A starting value can be a slightly higher number than the total number of tasks in the deployment.
To get the total of your tasks you can use the QVPR Analyser: https://community.qlik.com/docs/DOC-5892 Note that this tool is not a supported tool by Qlik.
- Save the file
- Start the QlikView Distribution Service
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.