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
StefanBackstrand
Partner - Specialist
Partner - Specialist

ParmGupta wrote:

If performance is an issue when you have 64 Cores and 1TB of RAM, you need to look at how the charts and tables in the dashboard have been defined.

Amen to that, brother.

pover
Luminary Alumni
Luminary Alumni
Author

I agree with you, Parminder.  When I have performance issues it is usually based on the fact that the application is faster in my laptop than in the server.  I know there is some overhead with so many CPU's, but I would hope that this is minimal.  Set analysis is usually the guilty suspect that makes everything so slow. 

Everything is now running as expected.

Karl

vgutkovsky
Master II
Master II

Hi, Karl. I'm experiencing the exact same issue at a client. HP Blade G7 server, massive processing power + memory, terrible performance. I changed all BIOS settings to what's recommended in Tip 8, changed the power mode to Max in Windows, and no luck. Do you still happen to have the HP ticket # from your support request?

Thanks,
Vlad

vgutkovsky
Master II
Master II

For all those interested, this turned out to be an acknowledged QV defect in versions 10 SR4, v11 IR and v11 SR1. The attached PDF provides instructions on how to fix.

Cheers,

Vlad

Not applicable

We are running QV 11.0.11307.0  on two HP ProLiant DL980`s G7 with 8 64-core Intel X7560 processors with  1 TB of RAM. As compared to our version 10 SR5 setup. We are noticing very poor performance opening documents via the  accesspoint using Ajax and slower reload times.  Let me of know of any settings that can be changed to improve performance.

Not applicable

11307, sounds like a customer patch.

are you able to install SR2?

Not applicable

Karl, Did you figureout the issue?

Not applicable

Hi everyone,

I am having same issue, poor perfomance with the following server.

QlikView Version 11.20 SR2.

IBM HX5 BLADE in COMPLEX Mode

SSD 50GB RAID 1

128GB DDR3

Windows 2008 R2 Enterprise (All fix pack/updated) & Tried Windows 2012 Standard (All fix pack/updated)

CPU E7-4807 1.86 X 4 CPU (6 Cores) = (24 Cores total) with Hyper threading deactivated

http://ark.intel.com/products/53569/Intel-Xeon-Processor-E7-4807-18M-Cache-1_86-GHz-4_80-GTs-Intel-Q...

Simple statistic calculation from a file size of 600MB Test took 4.30 Minutes

Over a less powerful blade it's took 30% less time to achieve same operation.

IBM HS22 Blade

SAS 146GB RAID 1

48GB DDR3

Windows 2008 R2 Enterprise (All fix pack/updated)

E5530 2.40 X 2 CPU (4 Cores) = (8 Cores total) with Hyper threading deactivated

http://ark.intel.com/products/37103/

Simple statistic calculation from a file size of 600MB Test took 3:06 Minutes

I followed all the possible document online about hardware setting and so on but wasn't able to improve the performance.

Quick tips #8 - Server Settings For Best Performance

I even tried running a VM on the HX5 over the SAN to rule out the internal SSD drive but that made absolutly no difference at all.

Any suggestion will be welcomed.

Thanks in advance!

Jason_Michaelides
Luminary Alumni
Luminary Alumni

I recently heard from a reliable source that 4-socket G7s may have a serious performance issue with QV. This could well go for other 4xCPU boxes.  Try halving the CPU affinity in QMC (System > Setup > QVS > Performance) by unticking half the boxes, restart QVS and see how that goes.

ggerber
Contributor II
Contributor II

I had similar experience on SR2.  Performance is much better after I had upgrade to SR3