The PostgreSQL instance used by Qlik Sense (on-premise) uses 100% of CPU capacity. This behavior can be seen in an interval of 2 hours.
Cause
The Resource Distribution Service is set to run a 2-hourly scan on all extensions and themes as part of a sync to Qlik Sense Cloud. This has proven to have a dramatic effect in very large environments where postgres.exe is causing the CPU to spike to 100% for an extended duration, making the environment unusable.
Resolution
Switch off Resource Distribution or set it to run every 24 hours.
Switch off Resource Distribution
- Open the services.conf file (default: C:\Program Files\Qlik\Sense\ServiceDispatcher\services.conf) in a text editor elevated to Administrator permissions
- Locate the [resource-distribution] section.
- Set Disabled to true:
[resource-distribution]
Disabled=true
Identity=Qlik.resource-distribution
DisplayName=Resource Distribution
ExePath=Node\node.exe
Script=..\ResourceDistributionService\server.js
- Save the file
- Restart the Service Dispatcher
Schedule it to run every 24 hours
- Open the services.conf file (default: C:\Program Files\Qlik\Sense\ServiceDispatcher\services.conf) in a text editor elevated to Administrator permissions
- Locate the [resource-distribution] section.
- Set Disabled to false as //Disabled=true:
[resource-distribution]
//Disabled=true
Identity=Qlik.resource-distribution
DisplayName=Resource Distribution
ExePath=Node\node.exe
Script=..\ResourceDistributionService\server.js
[resource-distribution.parameters]
--secure
--wes-port=${WESPort}
--mode=server
--log-path=${LogPath}
--log-level=info
--interval-time=86400000
- Save the file
- Restart the Service Dispatcher
Internal Investigation ID(s)
QB-18723
Environment
Qlik Sense Enterprise on Windows (November 2022 and later)
