topic Re: Does anybody tried hardware pre-fetch with qlikview 11? in Scalability

Does anybody tried hardware pre-fetch with qlikview 11?

davidmc1 — Tue, 10 Mar 2015 08:26:17 GMT

Hi all, i want to know if it will improve server response or even publisher reload time. We have hp proliant dl380p servers in our production environment, but we don't have same hardware in our development and test environments, so i cannot really verify behavior before changing production setting.

Thank you.

Re: Does anybody tried hardware pre-fetch with qlikview 11?

Anonymous — Thu, 26 Mar 2015 15:08:44 GMT

check my post, David

please help build a new server - HP DL380 or DL580

I did extensive testing and you situation might vary but I ended up with the following settings

BIOS settings:

hyperthreading is off, Enable HW prefetch, Enable NUMA, virtualization is off, Power set to High Performance, Turbo Boost is on

And I tested all combinations of these options above, was not fun!

Re: Does anybody tried hardware pre-fetch with qlikview 11?

davidmc1 — Tue, 31 Mar 2015 15:24:15 GMT

Thanks for sharing Boris! Great job. I was following it, i think you have tried on qvs.

I want to know also what about publisher.

However i have dl380 but not gen9, maybe its behaviour will be different and i've been told not to try.

Re: Does anybody tried hardware pre-fetch with qlikview 11?

Anonymous — Tue, 31 Mar 2015 15:44:40 GMT

sorry David, don't have anything to share in regards to publisher. I guess the only way is to test

Re: Does anybody tried hardware pre-fetch with qlikview 11?

Troy1 — Sun, 10 May 2015 17:25:03 GMT

Hi Boris

Most of qlikview recommendation based on best practice indicates to turn Numa off & hyper-threading on for "E5" cpu's. I am surprised you have Numa on and hyper threading off.

Can you please provide details as to what you saw in each test with Numa On & OFF & similar with Hyper threading ON and OFF.

below is the article that talks about best practice.

https://community.qlik.com/docs/DOC-2362