Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

Recommended practice on configuration for Qlik Sense

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Yoichi_Hirotake
Former Employee
Former Employee

Recommended practice on configuration for Qlik Sense

Last Update:

Feb 20, 2024 6:46:33 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 28, 2017 9:37:39 PM

This article provides a list of the best practices for Qlik Sense configuration. It is worth implementing each item, especially for a large environment so that your database can handle the volume of requests coming from all its connected nodes. 

 

Max Connections

For basic information, see Max Connections.

Specifies the maximum number of concurrent connections (max_connections) to the database. The default value for a single server is 100.

In a multi-node environment, this should be adjusted to the sum of all repository connection pools + 20. By default, this value is 110 per node. 

Assuming two nodes and assuming the default value of 110 per node, the value would be 240.

  1. Stop all of the Qlik Sense services
  2. Open C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\X.X\postgresql.conf
  3. Set max_connections = 110
  4. Save the file
  5. Restart all of the Qlik Sense Services

 

PostgresSQL_Max_connections.gif

 

How to determine the Database Max Pool

The value of 110 above is a default example. You can further refine the value.

The connection pool for the Qlik Sense Repository is always based on core count on the machine. To date, our advise is to take the core count of your machine and multiply it by five. This will be your max connection pool for the Repository Service for that node.

This should be a factor of CPU cores multiplied by five.

If 90 is higher than that result, leave 90 in place. Never decrease it.

For more information about Database Max Pool Size Connection, see https://wiki.postgresql.org/wiki/Number_Of_Database_Connections

 

Related Content:

Optimizing Performance for Qlik Sense Enterprise  
PostgreSQL: postgresql.conf and pg_hba.conf explained  
Database connection max pool reached in Qlik Sense Enterprise on Windows 

Labels (2)
Comments
Filippo_Nicolussi_P

To be aligned with the Qlik Sense Version we suggest to check on help. 

For example here  Installing Qlik Sense in a multi-node site ‒ Qlik Sense for administrators   for Qlik Sense May 2021 count seems 110 per node + 20 . 

Contributors
Version history
Last update:
‎2024-02-20 06:46 AM
Updated by: