QlikView memory issue-Deciding the memory

[shyamcharan]

Hi Experts,

Can you please suggest how can I decide how much memory would I need on the QlikView server?

I have server that has 19.5 RAM but due to huge amount of records(in Millions) the dashboard does not load on Access Point.

I get frequent reconnecting... message and the session is getting lost.

Now I need solid statistics that I can show to the client, How much memory the server need to have.

Can you anyone please suggest how can I achieve this?

I am sorry to tag it, but it is very critical to get send a quick response to my client. I appreciate any early responses.

Regards,

Shyam.

[Gysbert_Wassenaar]

Your question can't be answered with the information you provided. Not only the document size determines how much ram is needed. The number of users and their usage pattern matter, as do the server configuration and the topology of your Qlikview infastructure. And more besides. You should really ask your account manager for help with this.

But you can find some discussions about server sizing with this search: https://community.qlik.com/search.jspa?q=server+sizing‌. Perhaps you can already find some useful information this way.

[shyamcharan]

Thank you very much Gysbert.

I understand the Server RAM sizing on different factors. However, just to do a quick test I have done the following. It may not really make sense but these are the stats what I saw.

I have tested opening a QVD, QVW(on desktop and on Access point) to see the RAM usage and thought it would help to show it as an example. I may be totally wrong but please suggest.

Example 1:

The QVD file: 6.19 GB

QVW created on this QVD : 892 MB

Opened on Desktop QV app/RAM Usage: 6809 MB

Opened on QV Access Point: 7334 MB

Example 2:

A Table in DB:15.52 MB

QVD file Size: 5 MB

QVW created on this QVD: 1.8 MB

Opened on Desktop QV app/RAM Usage: 831 MB

Opened on QV Access Point: 725 MB

Let me know with comments.

Regards,

Shyam

[petter]

Document Analyzer V2 made by Rob Wunderlich might be of help to you:

Re: Document Analyzer V2 -- a major update

Furthermore a direct look at the .MEM file that you can export from any application you have load into QlikView Desktop should indicate resource demanding sections of your application - so you can restructure and optimize.

You find this on:

     Settings / Document Properties / General tab / Memory Statistics [button]

[Gysbert_Wassenaar]

QVD files contain a 'memory' dump of a table from a Qlikview in-memory database. When compared to for example a csv file the data in the qvd file is compressed. But a .qvw Qlikview document can have additional compression. This can be set in the document properties. That's why you cannot meanfully compare file sizes of qvd files and qvw files.

A Qlikview document with compression enabled will be decompressed when opened. The ram usage will therefore be larger than the file size.

A Qlikview document will usually contain charts. These have to be calculated. These calculations require RAM. Badly designed charts can use large amounts of RAM. More chart (and other sheet) objects means more calculations. Therefore the qvw files size does not say much about actual RAM usage.

When a Qlikview document is access by users through the Access Point the Qlikview Server will have to keep track of user session information. Each additional user will require additional RAM.

And lots more. Short story long, get a specialist that knows the ins and outs of server sizing.