topic Re: Performance issues on QlikView - IIS or QVWS in QlikView

Performance issues on QlikView - IIS or QVWS

Fri, 20 Nov 2020 18:02:30 GMT

We are quite new to QlikView. We are using QlikView 11.

We have a QVW on about 200Mb, with about 6.500.000 records.

We are a bit disappointed about performance on the the web app (Access Point). There is about 3-4 seconds on each click.

When I open the QVW directly on the server in QlikView Developer, it is very fast, but if I open the Access Point in Internet Explorer, also on the server, there is 3-4 seconds on each click.

We have installed QlikView server as a virtual server under VMWare. I know, QlikTech recommends a physical server, but I can also see here in QlikCommunity, that many of you are using virtual servers. And of course, it is a matter of price as we have all our servers in a hosting-center.

It is a fast server, with 64GB RAM allocated to this server - running Windows Server 2008 R2.

I can see, that you can use either QlikView own webserver QVWS or you can use IIS. We use QVWS.

Would there be any chance to improve performance with IIS ?

Re: Performance issues on QlikView - IIS or QVWS

jfkinspari — Tue, 21 May 2013 19:10:47 GMT

I haven't any experience in cases where IIS have improved the performance of an applications.

As the performance is good when opening directly on the server, the issue doesn't seem to be lack of CPU power, which otherwise could be the reason.

A more likely reason is that you need to open som ports which is causing the communication to be tunneled.

You can tjeck whether communication is tunneled by opening a session from the Access Point, and in another window log on to QMC, and see if any sessions i tunneled in the QMC Statistics/Performance tab. Look for TunneledDocSessions

Re: Performance issues on QlikView - IIS or QVWS

Tue, 21 May 2013 19:26:37 GMT

Hello Jens

I am not sure, where you mean.

Do you mean, QMC - Status - QVS Statistic - Performance?

See statistics below.

Firewall Inbound Roules for QlikView server:

TCP

Local ports: 4747, 4774, 4720, 4750, 80, 4780, 4799, 4730, 4735

Remote Ports: all

Firewall Outbound Roules for QlikView:

TCP

Local ports: All

Remote ports: 80,4747

ExeType	RLS64
ExeVersion	11.0.11440.0409.10
Timestamp	2013-05-21 21:23:21
DocSessions	1
AnonymousDocSessions	0
TunneledDocSessions	0
DocSessionStartsSinceMidnight	1
RefDocs	1
LoadedDocs	2
IpAddrs	1
Users	1
CPULoad	1
VMCommitted	2435.519531
VMAllocated	2762.855469
VMFree	59114.558594
VMLargestFreeBlock	59114.558594
UsageCalBalance	-1.000000
TimeZoneBias	-120
GBytesOfRamConfigured	44.7996955868
NumberOfCores	4
RecentCpuPercent	1
RecentRamOverload	0
OffDuty	false
Unlicensed	false

Re: Performance issues on QlikView - IIS or QVWS

jfkinspari — Tue, 21 May 2013 19:33:36 GMT

Yes, that's it.

However, TunneledDocSessions = 0, so this wasn't the issue.

Do you experience the same bad performance regardsless if you use IE-plugin or AJAX?

Re: Performance issues on QlikView - IIS or QVWS

Tue, 21 May 2013 19:37:54 GMT

I just tried to switch from AJAX to IE-plugin - and it seems much faster...

Re: Performance issues on QlikView - IIS or QVWS

Mon, 16 Sep 2013 14:12:21 GMT

Lige en opfølgning på ovenstående.

Vi oplever ind imellem, at der i QMC at værdien på TunneledDocSessions er over 0.

Jeg kan se, hvilke brugere der er aktive under "Active Users" og jeg kan se TunneledDocSessions under Perfomance. Men jeg kan desværre ikke se, hvilke Active Users der har TunneledDocSessions, så jeg kan kontakte dem og tjekke opsætning.

Er der mulighed for at se, hvilke Active Users der har TunneledDocSessions ???