Is there an up-to-date resource on best practices to help with performance, specifically server performance? We have ~10 applications on our production access point, and lately our server has been struggling on CPU with just a few people interacting with the apps.
Or perhaps its our hardware?
CPU: Intel(R) Xeon(R) CPU X5670 @ 2.93GHz (2 processors)
The question is is your CPU utilization high when users complain of performance issues? If the CPU is indeed spiking then you probably have charts/tables with complex calculations. Use the document analyzer tool to analyze your documents. Weed out expressions with IF statements and replace them with SET analysis. Weed out calculated dimensions and move those to the script.
About hardware - these are my recommendations
- Disable hyperthreading from the BIOS
- Disable NUMA from the BIOS
- Navigate to
Control Panel\System and Security\System -> Advanced System Settings -> Click Advanced -> Performance ->
Under the visual effects tab, select Adjust for best performance
Under the Advanced tab, select Background services for processor scheduling
- Next Control Panel\Hardware\Power Options - Choose "High Performance" power plan
Adding more memory might help as Qlik stores aggregations and calculated results in memory. Do note here that
=Sum(Sales)
is not equal to
=sum(Sales)
Qlik will use double the memory for these two as the expressions have to be identical in order for qlik to treat them as the same.
