topic Re: Hardware recommendation for a Qlikview developer client desktop pc. in QlikView

Hardware recommendation for a Qlikview developer client desktop pc.

qlikconsultant — Wed, 27 Apr 2016 13:38:03 GMT

Hi,

what is the Hardware recommendation for a Qlikview developer client desktop pc?

Re: Hardware recommendation for a Qlikview developer client desktop pc.

MK_QSL — Wed, 27 Apr 2016 13:44:49 GMT

QlikView 11.2 SR10 System Requirements.pdf

QlikView 11 System Requirements

Re: Hardware recommendation for a Qlikview developer client desktop pc.

ThornOfCrowns — Wed, 27 Apr 2016 13:50:23 GMT

This is the important bit:

Memory

Primary Memory: Although it is possible to run QlikView with less memory, the use of a computer with at least 1 GB for 32-bit Windows and 4 GB for 64-bit Windows is recommended. The amount of memory you need for QlikView depends on the amount of data you load, and on the data structure. Too little primary memory will drastically affect the performance of QlikView in a negative way. If you notice that your computer accesses the hard disk every time you make a selection in QlikView, you either have too many programs running, or too little primary memory.

Virtual Memory: Make sure that your swap file (the virtual memory) is large enough. The swap file should in principle be as large as possible. However, if you have limited disk space, or a lot of primary memory, you may want a smaller swap file or no swap file. The system usually takes care of the swap file size dynamically. However, if you have too little free space on the hard disk, you may get problems with your swap file getting too small. In such a case, you can fix the size of the swap file. This is done in the Virtual memory dialog, which is accessed from the task bar: choose Settings, Control Panel, System, Performance, Virtual Memory.

Re: Hardware recommendation for a Qlikview developer client desktop pc.

marcus_sommer — Wed, 27 Apr 2016 13:55:26 GMT

I think you need a serious estimation of the usally required amount of data and/or the maximum amount of data which are should be to applicable - without them everything is guessing.

- Marcus

Re: Hardware recommendation for a Qlikview developer client desktop pc.

Peter_Cammaert — Wed, 27 Apr 2016 13:58:19 GMT

4-core (or more) cpu, high clock freq.

16-32GB RAM, but that depends on how large your data stages or documents will be

SSD (R/W=500MB/s)

The only important thing is: buy enough RAM for your projects. You really don't want Windows to start swapping when loading a large amount of data.

Peter

Re: Hardware recommendation for a Qlikview developer client desktop pc.

qlikconsultant — Wed, 27 Apr 2016 13:59:17 GMT

Yes, but is there link. For example, if you report is 2 Gb big you need at least 16 GM Ram? And how much processor power do you need? Because from my experience the loadings process uses a lot of processor power.

Re: Hardware recommendation for a Qlikview developer client desktop pc.

swuehl — Wed, 27 Apr 2016 14:01:32 GMT

I've also seen companies having their developers actually remote login on a development server with decent amount of hardware ressources, so the PC's there are sitting on are rather basic.

Other than that, it might depend on the applications you are developing.

Most of the time, the actual development can be done using a subset of data (for example, 1 year data instead 5 years), so a typical modern desktop PC (x64, SSD, 8-16 GB) should be quite sufficient to work with.

Re: Hardware recommendation for a Qlikview developer client desktop pc.

swuehl — Wed, 27 Apr 2016 14:04:11 GMT

You can also have a look at

Re: Calculate how much RAM needed?

Re: How to project how much memory do I need to open a qvw?

to get some estimates from your applications.

Re: Hardware recommendation for a Qlikview developer client desktop pc.

marcus_sommer — Wed, 27 Apr 2016 14:04:49 GMT

The 2 GB from the report is compressed? Then it could easily expand to 16 GB within the RAM and you will be probably need at least 32 GB to handle it.

- Marcus

Re: Hardware recommendation for a Qlikview developer client desktop pc.

Anonymous — Wed, 27 Apr 2016 14:42:48 GMT

Yup. I usually RDP to a grunty Dev Server from a standard, basic spec laptop.

Re: Hardware recommendation for a Qlikview developer client desktop pc.

qlikconsultant — Thu, 28 Apr 2016 07:24:49 GMT

At the moment I use a Virtual Machine for development and the performance experience is terrible.

Any experince with virtual machines?

Re: Hardware recommendation for a Qlikview developer client desktop pc.

marcus_sommer — Thu, 28 Apr 2016 07:32:03 GMT

AFAIK not each VM is suitable and they need some specific configurations like fixed hardware-resources on CPU cores and RAM also no sharings with other VM's or tools.

What are the parameter from the host and from the VM?

- Marcus

Re: Hardware recommendation for a Qlikview developer client desktop pc.

Peter_Cammaert — Thu, 28 Apr 2016 07:35:04 GMT

IMHO that could be because of the following reasons:

Available RAM - QlikView as an in-memory app is extremely sensitive to RAM availability. Always make sure that enough free RAM is available, and that Windows does not swap to disk. Task manager is a simple and nice tool to check on RAM usage during those periods of terrible performance
VM Configuration - a number of settings must be taken care of when configuring a VM. The most important one is that resources must be permanently assigned to the QV VM, or the Virtual Machine manager may decide to temporarily relocate physical RAM to another VM. This is deadly to a QV installation.

If I can find a link to the QlikView-on-VM docment, I'll post a link in this thread.

Peter

Re: Hardware recommendation for a Qlikview developer client desktop pc.

Peter_Cammaert — Thu, 28 Apr 2016 07:39:23 GMT

See here:

Troubleshooting QlikView Server in a virtual environment 11/13

QlikView_and_Server_Virtualization_White_Paper_-_Copy.pdf

Re: Hardware recommendation for a Qlikview developer client desktop pc.

HirisH_V7 — Thu, 28 Apr 2016 08:23:21 GMT

Hi,

Based on your application size and multi tasking opening several apps at a time,

You can estimate accordingly,

Like this,

- 64bits operating systems since 32bits will not scale up more than 3Gb

- Intel i5 latest generation or above possible

-Hirish