topic Re: Server / Hardware Configuration in QlikView

Server / Hardware Configuration

Fri, 14 Mar 2014 13:01:20 GMT

HI Everyone

Was wondering how to decide what kind of server to get to run the Qlikview Server ? CPU? Memory? Disk?

Any whitepaper on how to make these kinds of decisions??

Regards

Meir

Re: Server / Hardware Configuration

markodonovan — Fri, 14 Mar 2014 13:08:33 GMT

Hi Meir,

Have a look at this document.

Hope it helps.

Mark

https://www.techstuffy.com/product/practical-qlikview-pdf-download/

Re: Server / Hardware Configuration

Fri, 14 Mar 2014 13:19:18 GMT

Thanks for the link. From the Contents it doesn't look like you mention how to decide on the hardware.

Regards

Re: Server / Hardware Configuration

markodonovan — Fri, 14 Mar 2014 14:04:13 GMT

Hi Meir,

The attachment should give you some guidelines for Memory usage etc...

Here are some points I have used in the past.

RAM USED DEPENDS ON:

=========

number of users,

the number of apps

volume of data in use.

Processors

==========

Intel instead of AMD.

Intel performs better with QlikView (a result of architecture).

Use maximum number of processor slots used.

Memory

======

factors:

=======

size and complexity of the data,

composition of the application, type of user etc)

rough calculations:

==================

Size on disk = 10% of source data size

Size in memory = 4 x size on disk

Memory per user = 5% of size on disk

So for a 10GB data source with 5 users this would be 1GB on disk,

4GB in memory and 50MB in memory per user.

Disk Storage

============

There only needs to be enough disk storage to hold the required applications.

This can be configured in a Raid 1 configuration.

If you need to do some benchmarking have a look at the following document:

http://community.qlik.com/docs/DOC-2942

Hope this helps

Mark

Re: Server / Hardware Configuration

markodonovan — Fri, 14 Mar 2014 14:21:35 GMT

Hi Meir,

Here is a useful post for more detailed capacity planning:

http://community.qlik.com/message/259471#259471

Thanks

Mark