Qlik Community

Qlik Scalability

A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.

Highlighted
philbishop
Contributor

Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

My customer would like to use 2 Dell PowerEdge R910 servers for his dedicated QlikView Servers (1 for Publisher and 1 for Server). In one of the servers, he is configuring for only half the CPU slots (2 instead of all 4). Has anyone seen this configuration and do you know if it causes any performance issues? Would it be better to recommend the Dell PowerEdge R720 server for the 2 slot configuration?

Thanks,

Phil

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

Hi Phil,

Both the R910 and the R720 (fully stocked) are great selections on hardware.

There are some key differences though, particularly with supported chipset and CPU interconnects (QPI links).

The short answer is that performance would be improved with the R720 over the R910 with only two chipsets.

Especially if a fast CPU is used for R720 (such as the E5-2690).

The R910 only has one QPI between the CPUs whereas the R720 has two QPIs.

Add the increased clock frequency for the R720 and the selection should be straightforward.

Generally Publisher tasks (reloads) have been shown to have a high correlation towards clock frequency and a strong recommendation would be to go for the R720.

Comparing a fully stocked R910 versus an R720 as a QlikView server is harder as the R910 regains performance by having much more computational capacity despite the slightly slower clock frequency.

The presentations and white papers attached by Jonas Heisterkamp and Jim Harder are however a good read.

Regards,

Hampus von Post

View solution in original post

5 Replies
jharder22
New Contributor III

Re: Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

Hi Phil,

There are some great QT documents from the Scalability Center that will speak to this - From my experience the best server performance is to have all slots in the chassis loaded with processors, rather than filling only two slots of a four slot machine. Optionally the customer could get the two slot Dell with two processors, but that would potentially limit the capacity of that server. The other way would be to load all four slots with less capable processors i.e. two core vs four core, then as the requirements grow they would just swap out the smaller processor for larger quad core or hex core processors. I'll have a look for the documents and post those in a minute.

Good Luck

Partner
Partner

Re: Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

Hi Phil,

you get a bigger overhead in data and or response time on the hardware, for each component which need to be address.

Between a 2 socket and 4 socket motherboard you have, if the design is optimized, more complexity in the inter socket connect. This mean the communication between the cpu.

You can find some information in the atachment.

jharder22
New Contributor III

Re: Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

Qlik WHite Paper

Employee
Employee

Re: Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

Hi Phil,

Both the R910 and the R720 (fully stocked) are great selections on hardware.

There are some key differences though, particularly with supported chipset and CPU interconnects (QPI links).

The short answer is that performance would be improved with the R720 over the R910 with only two chipsets.

Especially if a fast CPU is used for R720 (such as the E5-2690).

The R910 only has one QPI between the CPUs whereas the R720 has two QPIs.

Add the increased clock frequency for the R720 and the selection should be straightforward.

Generally Publisher tasks (reloads) have been shown to have a high correlation towards clock frequency and a strong recommendation would be to go for the R720.

Comparing a fully stocked R910 versus an R720 as a QlikView server is harder as the R910 regains performance by having much more computational capacity despite the slightly slower clock frequency.

The presentations and white papers attached by Jonas Heisterkamp and Jim Harder are however a good read.

Regards,

Hampus von Post

View solution in original post

philbishop
Contributor

Re: Are there drawbacks to configuring a 4-slot server with only 2 slots populated?

Thanks Jim, Jonas and Hampus for your answers. This was very helpful. Ultimately, the customer will decide what they want, but they now have the information they need to make a better decision. I will try to update this post based on their actual experience once we are up and running.

-Phil