Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

diwakarnahata
Contributor

Application consuming too much RAM

Hi All,

I am facing a weird issue, where some of the sheets of my application is consuming all the available RAM of Server which is accessed through Access Point.

There are 15 sheets in the application and the total size of the .qvw file is ~1 GB. The available RAM on the Server is 100+ GB. There are approx. 5-7 users accessing the Application from Access Point as of now.

The application extensively uses : Triggers, Different types of Charts, Dynamic dimensions, Alternate State, variables, etc. to achieve the desired functionality, but the moment some of the sheets are opened the RAM consumption goes very high and within 1-2 minutes it consumes all the RAM and the Server becomes in-accessible. If we do not open those sheets, the RAM consumption is between 20 to 50 GB (just an observation).

Any idea what can cause a small application (~1 GB in size) to consume > 100 GB of RAM?

Is it the application design or Server configuration or corrupt document or anything else which is causing this issue?

Let me know if any more information is needed.

Regards,

Diwakar

Tags (3)
7 Replies

Re: Application consuming too much RAM

In debug mode try a limited load of 10 or fewer rows. This indicate if your problem is due to invalid associations between tables or synthetic keys.

Otherwise check that you are not combining data from tables that are not associated - this will cause a cartesian join between the tables.

If table A has 100,000 rows and table B has 100,000 rows and the tables are not associated, using fields from table A and B in the same chart will cause QlikView to generate 100,000 x 100,000 roes of data 10,000,000,000 rows!

Hence you run out of RAM.

maleksafa
Valued Contributor

Re: Application consuming too much RAM

so if the problem is only in one of the sheets, i recommend to generate the .mem file or check the calculation time of the charts in this sheet to see what is the chart that is causing this anomaly, check if you have calculated dimensions (not recommended) and if you have complex expressions maybe it would be better to minimize the charts by default or add calculation conditions on the charts to force the users to make selections before displaying this chart this will definitely improve the performance. other thing to check is the triggers on the sheet opening.

prieper
Honored Contributor II

Re: Application consuming too much RAM

Agree with Malek,

unfortunately QV does not have tools available to dedect, which object requires the RAM (unless opened).

If open, the MEM.file might assist.

We went through the painful way in opening each object in each sheet and to watch the RAM-consumption simultaneously on the server in order to identify the object.

Finally it turned out to a combination of several causes: a calculation referring to the total number of records, an object (pivot-table), building a cartesian product and finally a clone of this object as server-object ....

Peter

MVP
MVP

Re: Application consuming too much RAM

Hi,

The main issue comes with the tables, if you displaying huge set of rows then you will get this issue or if you are doing any complicated expressions or many calculations.

You can check the memory occupied by various objects in

Sheet Properties -> Objects -> check CalcTime and Memory

Memory - is the size of the object

CalcTime - is the time taken for the calculation.

Based on this you can proceed further by limiting the number of rows display by forcing user to select some filters.

Regards,

Jagan.

engishfaque
Valued Contributor III

Re: Application consuming too much RAM

Dear Diwakar,

I suggest you to restart your machine and try to use "QlikView Governance Dashboard" to find any abnormality.

Kind regards,

Ishfaque Ahmed

bestofwest
Contributor II

Re: Application consuming too much RAM

Problems with data model.

Verify relations between tables (entities) on Table Viewer.


Try generate QVD outside QS and QV.

diwakarnahata
Contributor

Re: Application consuming too much RAM

Hi All,

Thank you for all the replies.

I went and check each expression on each Sheet and found that a few expressions which were using the AGGR function were taking up all the RAM.

It working a lot better now!!

Thanks once again.

Regards,

Diwakar

Community Browser