Qlikview Performance

[HimanshuKakade]

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.

[tresesco]

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

[Alexis_Touet]

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...

Best regards, 

Alexis 

[Sonja_Bauernfeind]

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.

[Brett_Bleess]

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