topic Qlikview Performance on Windows Servers in QlikView

Qlikview Performance on Windows Servers

Tue, 13 Apr 2010 18:53:43 GMT

Hi Folks,

I'm working on a qlikview report in Windows 2008 server,for some reason the report navigation(selections etc..) is slower on the server where as it is faster in my local machine.Does anybody know what is making the navigation slower on a server?

Thanks,Santhosh.

Qlikview Performance on Windows Servers

StefanBackstrand — Tue, 13 Apr 2010 19:33:39 GMT

Can you supply more details, please?

Is the server virtual? x86 or x64? RAM amount? CPU core count.

Qlikview Performance on Windows Servers

Tue, 13 Apr 2010 19:41:37 GMT

Hi Stefan,

The Server is Virtual,x64,16 GB RAM and 8 processors.

Thanks,

Santhosh.

Qlikview Performance on Windows Servers

StefanBackstrand — Tue, 13 Apr 2010 21:08:12 GMT

Does the virtualization hypervisor overcommit resources or baloon memory? That could cause QVS to get "squeezed" when allocating memory or performing calculations. Have you changed the CPU core count since QVS was installed? If yes, have you altered the core affinity in QV QEMC?

Make sure that the QVS event log verbosity is set to High/Debug, and restart the QVS service to see if the Working Set limit values are actually enforced. They default at 70/90 (% of physical RAM), and the log entry at service start should log what amount of RAM is set as WS limits. In your case somwhere around 11/14 GB, as default.