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.

Not applicable

Re: Server with 2 sets of CPU's

Any document stating such thing? How many core should I leave check marked?

Highlighted
Partner
Partner

Re: Server with 2 sets of CPU's

Hi,

In a single user scenario it's way better to haver fewer but faster cores than to have more but slower cores.

The fact that the information has to be split up to be fed to the cores and then joined back always creates an overhead. Overhead results in a performance loss.

In a multiple user scenario that is not a linear conclusion one can draw, but that's usually the case.

Regards,

Carlos

Employee
Employee

Re: Server with 2 sets of CPU's

Hi Mohamed,

In your case you have likely created calculations that are single threaded. This could be due to many factors such as

expressions, data model and so forth.

When calculations are single threaded QlikView Server (QVS) will only utilize a single core for all or parts of the operation. With 100% single threaded calculation computation time is directly correlated to core clock speed. 

Your previous hardware ran at 2.4 GHz and your newer runs at 1.86 GHz.

2.4 divided by 1.86 yields about 30% difference, which is exactly what you mention.

So if possible do get high clock speed CPUs, and as always do refer to your local QlikView representative and/or QlikView partner for advice on server recommendations.

The new server is however much more capable at handling more simultaneous users and applications as the theoretical computational capacity is three to four times the previous one, but for this single user single application test your older is faster only due to clock/core speed.

Regards,

Hampus

Partner
Partner

Re: Server with 2 sets of CPU's

Half of them at first. Then try various affinities I would guess.

Employee
Employee

Re: Server with 2 sets of CPU's

"4-socket G7s".


Are you referring to HP 4-socket G7?

A specific model?


QlikView works very well with many 4-socket servers.


Always refer to your local QlikView representative and/or QlikView partner as they have a list of well proven and recommended servers.

Not applicable

Re: Server with 2 sets of CPU's

I even lower the spec of the HX5, in SIMPLEX mode with almost the same specs then the HS22 but the result where not better or poor it was still taking me over 4 minutes to run the statistic.

Not applicable

Re: Server with 2 sets of CPU's

I tried that, it made no difference.

Not improving or making things worse.

Not applicable

Re: Server with 2 sets of CPU's

But I also tried the HX5 in simplex mode same specs wise beside the cpu and I was still getting the same result around 4 minutes. Is that normal?

Sent from my iPhone

Partner
Partner

Re: Server with 2 sets of CPU's

Yes Hampus - HP boxes.  I've not tried it but that;'s what I heard.  We are using 2-socket G8's right now.

Not applicable

Re: Server with 2 sets of CPU's

Mr.Hampus von Post

Thanks for you explanation.

Can you please tell us why we see activity over all cores when we run the satistic test then?

qlikview.png