Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
pover
Luminary Alumni
Luminary Alumni

Server with 2 sets of CPU's

Hello,

We're reviewing a server with 2 sets of CPU's.  Each set is on a different card and has 4 CPU's.  Anyone ever have problems with this hardware configuration?

Thanks and regards.

30 Replies
hps
Employee
Employee

Hi Mohamed,

Yes there is activity across all cores, so the operation is not single threaded at all times. A calculation done by QVS does not necessarily reside on the same core throughout the calculation. In you case it is still single threaded to a high degree as the overall CPU utilization is low despite having long response times, but all the small sub calculations required could be done by any core sequentially.

Normally with large and single threaded calculations there would be a much clearer indication that a single core is used.

There is an excellent post by Henric Cronström on the calculation engine that's invaluable.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/20/the-calculation-engine

To summarize, with the way your application utilized hardware it is very dependent on single core clock speed.

I recommend that attention is given to:

* Does the table have "calculated dimensions",

* Could the expressions be optimized

* Is the data model simple

As I stated before refer to QlikView partner and/or QlikView representatives when selecting hardware,

and if you feel you would like to ask further questions on performance and improvement for your specific document, QlikView Expert Services is great reasource.

Regards,

Hampus von Post