topic Re: Qlikview Performance in QlikView

Qlikview Performance

HimanshuKakade — Sat, 16 Nov 2024 03:30:04 GMT

Hi,

We have a same dashboard present on Server A to Server B.

We observed that the performance of the dashboard on Server B is slower than that of Server A.

If the dashboards present on both the servers are exact same in design, data and memory.

What are the others factors that are affecting the performance.

What all factors should we compare on both the servers to figure out why the performance is slow on Server B.

Kindly guide.

Re: Qlikview Performance

tresB — Thu, 23 May 2019 08:05:51 GMT

If both the servers are of same configuration, I would start with checking things like:

- Which services/processes (if any), consuming resources in server b, may be other dashboards or anti-virus

- Compare network latency for servers

Re: Qlikview Performance

Alexis_Touet — Thu, 23 May 2019 08:45:11 GMT

Hi

Another hint, I would also check Bios settings if on physical servers:

https://community.qlik.com/t5/Qlik-Scalability/Quick-tips-8-Server-Settings-For-Best-Performance/gpm-p/1487578

Best regards,

Alexis

Re: Qlikview Performance

Sonja_Bauernfeind — Thu, 23 May 2019 09:02:53 GMT

This all factors in on Qlik performance:

The CPU (clock speed, etc)
Memory access speed
BIOS settings (as mentioned by Alexis)
Storage! What storage is used for .qvw files, etc https://support.qlik.com/articles/000050593
Virtualization https://support.qlik.com/articles/000029234
Network latency

Once those are compared, it's a matter of looking into what else on the machine may be draining resources, or if behaviour patterns of users might have changed, requiring more resources now than before.

Re: Qlikview Performance

Brett_Bleess — Thu, 27 Jun 2019 18:37:21 GMT

I have one more to add to Sonja's list, Windows Control Panel Power Options, be sure that is set to High or Maximum Performance and not Balanced, as sometimes in the Balanced setting, the CPUs are not able to hit their turbo frequency thus causing a pretty significant performance hit too.

Regards,
Brett