QlikView Server benefits from the following server settings on average:
Disabled (most architectures), Enabled (2 socket Intel E5-XXXX architectures)
Power Management (Power profile)
Max performance (BIOS and windows setting)
Enabled (i.e. NUMA disabled), see below for further information
Intel Turbo Boost
Enabled (when present)
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.
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