Server with 2 sets of CPU's - Qlik Community

pover · ‎2011-05-26

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.

StefanBackstrand · ‎2011-06-07

Can you elaborate a bit more? What do you mean with sets? Cards? Are there any tech specs?

I haven't seen such convoys myself, if I don't misunderstand the description. But that's only me. 🙂

pover · ‎2011-06-16

Hello Stefan,

The machine is a HP ProLiant DL980 G7 with 8 8-core Intel X7560 processors on 2 separate trays and 1 TB of RAM. I've attached more detailed specifications. We were seeing poor performance a couple weeks ago, but HP seems to have fixed it because the performance has improved.

Regards.

Report Inappropriate Content · ‎2011-06-20

cpu hyper-threading is enabled ?

pablolabbe · ‎2012-02-10

Hi Karl,

Did you solved the performance problem ?

Regards,

Pablo

pover · ‎2012-02-10

Pablo,

Sadly, the performance improved without knowing what the hardware provider did. We improved by a couple more seconds using info from tip #8 http://community.qlik.com/docs/DOC-2362

My advice to anybody who believes they have a server performance issue is to look at the QV app itself. I've seen response times reduced 50-60% by changing the RAM configuration or BIOS, but that never seems to be enough for user that expects 1-2 second response times. To achieve those type of response times, you probably need to reduce the data volume or the complexity of the expressions.

Karl

pablolabbe · ‎2012-02-12

Hi Karl !

The referenced document are part of a valuable section of the Qlikview Scalabity Group that I´ve seen it before. Thank you.

However, can you share with us how large are your environment that requires this kind of hardware ? A server with 1 TB of RAM isn't a common one.

Best Regards,

Pablo Labbe

Qlikview Consultant

www.visiongi.com.br

pover · ‎2012-02-12

Hi Pablo,

It's not so much that the environment is large. I've only ever seen 120 GB being used at one time. I haven't analyzed the log data, but there are 138 Named CAL's and 600 Document CAL's. The source data has billions of rows of data, but we're using QV apps with weekly aggregated data reduced to the last 2 years in most cases.

The server is so large because of the potential number of users and data in the next couple of years. Looking back on the whole evolution of QV, in my opinion, it would have been better to purchase a server half that size and add an additional clustered in the future.

Karl

Report Inappropriate Content · ‎2012-02-12

Hi Karl,

Yes clustering two servers with 512gb of RAM would have been better choice. Because, some days back we just had a discussion with someone from Qliktech and he suggested that performance does not go well with more than 512gb of RAM, so in these cases he suggested clustered enviornment.

Just my 2 cents.

..

Ashutosh

Report Inappropriate Content · ‎2012-03-02

Clustering would only help you if you have multiple dashboards.

From what you have said above , it seems you have one large dashboard , clustering would not improve the performance.

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.

Are you doing complex calculations in the dashboard in multiple charts / tables ? Could these calculations be done on the Database before the data set is extracted ?

Are you using nexted if statements ? could you replace these with flags ?

It might not be a server scalablity issue at all ...