Quick tips #8 - Server Settings For Best Performance

QlikView Server benefits from the following server settings on average:

 

Setting/Configuration

Value/Information

Hyper-threading

Disabled (most architectures), Enabled (2 socket Intel E5-XXXX architectures)

Power Management (Power profile)

Max performance (BIOS and windows setting)

Node Interleaving

Enabled (i.e. NUMA disabled), see below for further information

Intel Turbo Boost

Enabled (when present)

Memory configuration

Configured for best performance, see below for further information

Different manufacturers and models have different names and ways on how to tune these settings. Look in the manual for equivalents to what has been listed above.

 

NUMA

For some servers it is not possible to disable NUMA in BIOS. Since QV10 SR4 logic has been implemented for QVS to ignore the use of NUMA nodes when allocating memory even if NUMA is enabled.

QV10SR4 – QV11.2 SR1: This cannot be managed in the QMC and must be set in the Settings.ini file as a [Settings 7] entry

EnableNumaRoundRobin=1 means enable functionality which should be used for servers where NUMA cannot be disabled in the hardware

EnableNumaRoundRobin=0 is defaulted and means disabled functionality.

 

Since 11.2 SR2: QVS is defaulted to an automated state that detects NUMA status and set EnableNumaRoundRobin setting in accordance to recommendations.

 

Further settings and configurations to check into:

Memory: Memory should be evenly distributed over available slots (i.e. same amount of RAM per CPU) and populated in accordance to HW manufacturer specifications for best performance. Aim for hemisphere mode if present.

 

BIOS setting Hardware pre-fetch has been shown to make difference in performance. However, due to diverse results from analysis of different document designs and user scenarios value for this setting should be verified per setup.


Cheers from the Scalability Team