QVServer reload are much more slower than local reload

[septo888]

Hello,

Im using QV for several years now and QVServer reloads was always faster than my local reloads. But, for a while now (Maybe since the migrate from QV11 to QV12 but not sure...), reloads from QVServer are much MUCH slower than my local reloads using my destkop version.

Just an example: 23min in local reload and 1h10min with QVServer.

This behavior concern all applications.

• My local hardware, used for local reload with desktop version:

Intel Core i5-62000U CPU 2.40 GHz

16 Go RAM

x64

• The QV Server informations:

Product Information
		Product name	QlikView Distribution Service x64
		Client Build Number	12.20.20700.0
		Target Platform	x64
		QlikView Build Info	QV12-20/150
	Current Process Information
		User Domain Name	xxxxx
		User Name	xxxxx
		Start Directory	C:\Program Files\QlikView\Distribution Service
		File Name	QVDistributionService.exe
		Process ID	2224
		Base Priority	8
		Processor Affinity	63
		Privileged Processor Time	00:00:10.3750000
		Input Language	Français (fr-FR)
		Working Set	220639232
		Minimum Working Set	204800
		Maximum Working Set	1413120
	Machine Information
		Computer Name	xxxxx
		Operating System Version	Win32_OperatingSystem=@ X64 (Microsoft Windows NT 6.1.7601 Service Pack 1)
		.NET Version	4.0.30319.42000
		MDAC Version	6.1.7601.17514
		Monitors	1
		Physical Memory	36863Mb
		Available Memory	25988Mb
	CPU Information
		CPU 0	Intel(R) Xeon(R) CPU X5660 @ 2.80GHz
		CPU 1	Intel(R) Xeon(R) CPU X5660 @ 2.80GHz
		CPU 2	Intel(R) Xeon(R) CPU X5660 @ 2.80GHz
		CPU 3	Intel(R) Xeon(R) CPU X5660 @ 2.80GHz
		CPU 4	Intel(R) Xeon(R) CPU X5660 @ 2.80GHz
		CPU 5	Intel(R) Xeon(R) CPU X5660 @ 2.80GHz

Is there something wrong with the server settings ?

Any ideas ?

Thanks

[Miguel_Angel_Baeyens]

The Distribution Service in QlikView 12 is more intensive in the use of resources (namely, RAM and CPU) than QlikView 11.20. This may lead, as it did in our case, to lots of tasks competing for those resources, and it turn, taking longer instead of faster to reload.

There are some settings you can adjust, starting by the number of concurrent tasks (I don't know your environment and tasks, but somewhere between 4 and 6, no more than that) and others you can find in the Qlik Support portal, such as

• New settings in QDS 12: https://qliksupport.force.com/articles/000031003
• Queued tasks: https://qliksupport.force.com/articles/Basic/Tasks-are-not-executed-as-expected-and-are-shown-in-sta...
• Resource consumption in QlikView 12: https://qliksupport.force.com/articles/000046729‌

We also had other non-QlikView related issues like connecting to active directory, which was taking a lot more time than usual and we had to tweak those queries.

[schefflera]

We had the same issue. We used a virtual machine in the past. The Service was taking much longer than on local machine. Especially after Update to Version 12.x. We had 48 GB RAM but QV just used 20 GB for the Service and reload. We tried several different setting in the server settings, but without success.

We then switched to a hardware machine with 128 GB RAM and now there will be almost 90 GB RAM allocated and the reload is a bit faster than on local machin but compared to our previous machine it take almost 4 hours less to reload the files.

Maybe you try to upgrade your RAM or try a hardware server if you use VM.

You also should check that the QV Version on you local machine is the same on your server.