Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
christianw
Contributor II
Contributor II

QlikView CPU sizing - sockets vs cores

8 CPUs are assigned to our QlikView server. This is specifically recommended against by Qlik: Qlik’s Recommended Servers - Eight-socket configurations: Do not use these types of configurations with Qlik Sense or QlikView as they do not provide direct connections between all sockets

https://www.qlik.com/us/-/media/files/resource-library/global-us/direct/datasheets/ds-qlik-scalabili...

Is there any recommendation for cores instead of sockets? We have a VMware environment where we can decrease to 2 sockets with 4 cores each, or increase to 2 sockets with 8 cores each to keep the sockets down but increase the number of CPUs. Our ESXi host has plenty of CPU cores available, but is an older CPU model (Sandy Bridge), and we notice significant slowdowns at times, with all 8 CPU sockets at 100% for 15 mins or longer.

Will switching from 8 sockets to 2 sockets (with multiple cores) help us with this performance issue?

Labels (1)
1 Solution

Accepted Solutions
christianw
Contributor II
Contributor II
Author

For anyone with this issue - changing from 8 sockets to 1 socket with 8 cores made absolutely no difference - if anything, it made the QlikView server slower.

As this was a VMware hosted server, we used hot-add to make it 3x 12 core CPUs, and restarted QVS, then reconfigured the server to not use two cores (saved for the OS), and this seemed to help.

View solution in original post

3 Replies
Alan_Slaughter
Support
Support

Hi Christianw, I would suggest the following link and also reaching out to your account manager so that they could do a proper sizing for your needs. 

https://community.qlik.com/t5/Official-Support-Articles/Virtualization-Best-Practices-In-QlikView-An...

christianw
Contributor II
Contributor II
Author

Thanks for your reply and the link to some articles. However, the documents linked and the information provided do not answer the question I have, hence the post.
For context, I have been brought in as a consultant to investigate and resolve performance issues with Qlik View, and I was selected to do this work because I used to be an employee of VMware and so I have a deep and complete knowledge of virtualisation. The current Qlik View servers are a P2V conversion of physical machines, and have been allocated 8 sockets, which is directly recommended against within the "Recommended Top Performing Servers" article, as I linked and quoted in my original post.

Back to the original question, asked in a different way - is there any knowledge or metrics on known performance differences between multi-core versus multi-socket systems? If I switch from an 8 socket (with only one 'core' per socket) to 2 socket (with 4 cores per socket) - on the same physical hardware, will this make a noticeable difference?

christianw
Contributor II
Contributor II
Author

For anyone with this issue - changing from 8 sockets to 1 socket with 8 cores made absolutely no difference - if anything, it made the QlikView server slower.

As this was a VMware hosted server, we used hot-add to make it 3x 12 core CPUs, and restarted QVS, then reconfigured the server to not use two cores (saved for the OS), and this seemed to help.