Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Windows 2012 QlikView 11.20.12577.0 AJAX Access Point Slow

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.

19 Replies
agomes1971
Specialist II
Specialist II

Hi,

in addition please also see this post...

Qlikview doc slow to load first time from AccessPoint

Thanks

André Gomes

Not applicable
Author

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

Giuseppe_Novello

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

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
Not applicable
Author

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

Giuseppe_Novello

Petr,

Ok, well hopefully some can help you.. good luck!

Gio

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
agomes1971
Specialist II
Specialist II

Hi,

Ports used by QlikView.

NameNoteProtocollocal Port
QlikView ServerQV.exe  / QlikOCX using qvp://TCP4747
QlikView Server TunnelInternal tunnel communicationTCP4774
AccespointHTTPTCP80
AccespointHTTPSTCP443
QMC / QEMCTCP4780
Comand Center *TCP4710
Distribution ServiceTCP4720
Directory Service ConnectorTCP4730
Directory Service Connector (DMS or Custom)TCP4735
WebServerTCP4750
Remote QMSTCP4799
Qvs.exeQVS cluster broadcastUDP14747
Comand Center *SNMPUDP4711
Management ServiceSNMPUDP4781
QlikView ServerSNMPUDP4748
Distribution ServiceSNMPUDP4721
DirectoryServiceConnectorSNMPUDP4731
agomes1971
Specialist II
Specialist II

Hi Petr,

any news?

André Gomes

Not applicable
Author

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

agomes1971
Specialist II
Specialist II

Thank you Petr

Anonymous
Not applicable
Author

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