Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have noticed there are other discussions around but no solution provided so far:
We have setup a new environment on Windows 2012 Server R2. We used the binary 2012 and up Version 11.20.12577.0.
We are able to execue our main app on the server in the matching fat client => performance is very good
We are able to use the IE Plugin => Performance is very good
When we do start the same report in the AJAX client the performance is very bad. Every click takes around 1 second. Even if nearly no data is selected. Even if only changing the status of a check box. After a few minute the connection breaks by showing only the "busy" mouse coursor.
Memory and CPU usage is independent of the accessmethod low low:
Physical RAM(MB) | 65501 | ||
VMCommitted(MB) | 971 | ||
VMAllocated(MB) | 1254 | ||
VMFree(MB) | 58196 | ||
VMLargestFreeBlock(MB) | 58196 |
CPU Cores: 32 x Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz 1995MHz. CPU utilization when performing queries: about 1%
So far I was assuming that a network problem / proxy / firewall could cause the problem but even if the browser on the server is used to access the AJAX interface the performance is bad and if used with the IE Plugin the performance is good everywhere.
We have checked that the connection is not tunneld via port 80. All relevant ports are open: 4747, 4774, 4720, 4750, 80, 4780, 4799, 4730, 4735. We have also restarted all QlikView Services before testing the performance.
As I have read that other people do have similar problems with Windows 2012 => could this be related to Win 2012, Ist it related to the Qlik SP we are using?
Any ideas are welcome.
Hi,
in addition please also see this post...
Qlikview doc slow to load first time from AccessPoint
Thanks
André Gomes
Hi André
Thank you for checking on this. We do have the same effects if accessing the document with browser installed on the server using the 127.0.0.1 loopback address. So I think we can exclude the Firewall from the list off possible causes.
As well now tunneling is happening (we checked if any sessions are tunneled in QMC).
Regards
Petr
Petr,
If IE work fine bur Ajax its performance degrades, it is either in the document something that is making it slow.
1- .Shared files -> recreate/rename the original shared file of that document.
2- Macros -> Ajax works a single threaded, so if you have macros it will get a big performance impact.
3- Document Trigger, ex "OnOpen" - > same like macros.
Hope it helps.
Gio
Hi Giuseppe
Thank you so much for this new idea.
However we have no macros in the document and the performance don't degrade over time but it starts off bad immediatelly.
To test what you proposed I have created a new report with only a few thousand rows in one table. Just one pivot diagram and 1 chart => same effect.
Regards
Petr
Petr,
Ok, well hopefully some can help you.. good luck!
Gio
Hi,
Ports used by QlikView.
Name | Note | Protocol | local Port |
QlikView Server | QV.exe / QlikOCX using qvp:// | TCP | 4747 |
QlikView Server Tunnel | Internal tunnel communication | TCP | 4774 |
Accespoint | HTTP | TCP | 80 |
Accespoint | HTTPS | TCP | 443 |
QMC / QEMC | TCP | 4780 | |
Comand Center * | TCP | 4710 | |
Distribution Service | TCP | 4720 | |
Directory Service Connector | TCP | 4730 | |
Directory Service Connector (DMS or Custom) | TCP | 4735 | |
WebServer | TCP | 4750 | |
Remote QMS | TCP | 4799 | |
Qvs.exe | QVS cluster broadcast | UDP | 14747 |
Comand Center * | SNMP | UDP | 4711 |
Management Service | SNMP | UDP | 4781 |
QlikView Server | SNMP | UDP | 4748 |
Distribution Service | SNMP | UDP | 4721 |
DirectoryServiceConnector | SNMP | UDP | 4731 |
Hi Petr,
any news?
André Gomes
Hi
I have updated the server to SR9 to be sure that it isn't a problem that was already fixed. As I tried all suggestions - even reinstalled the server following all manuals I will now raise a ticket with support.
Thanks again for all suggestions.
Regards
Petr
Thank you Petr
Hello petrbeles did you get any answer from support? Did you manage to solve it?
I'm having the same issue, via AJAX it takes 12 sec and via IEPlugin just 2 sec.
BR
Dai