The QlikView Distribution Service (QDS) is consuming a high percentage of overall CPU capacity. No tasks are actively running. Environment:
QlikView 12.20 (November 2017)
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
Task files need to be updated regularly. It is possible to adjust the number of tasks updated per thread.
- 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.
- Save the file
- Start the QlikView Distribution Service