Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
shayraber
Creator
Creator

RAM usage by users won't release

Hi all,

I'm facing an issue lately with my QV server deployment.

recently, users tend to get very often an error message saying the server is unreachable (and they can't open documents via access point).

exploring that issue led me to the conclusion is high RAM usage which is solved only by restarting the Qlikview server service.

what I've noticed is that users which opens documents increase (as expected) the RAM usage, BUT when they close the documents the RAM they used is NOT releasing... the RAM usage only keeps increasing and increasing until users can no longer open documents until a restart is being made.

I've read this thread:

RAM usage high

which explains that this is how QV originally designed to work (use every available RAM for better end-user experience) but what if that RAM usage effects badly on other users?

it doesn't seem right to schedule a service restart few times a day...

any other idea? suggestion?

please assist

32 Replies
shayraber
Creator
Creator
Author

B.T.W

does it also in addition to limit the Document timeout? as was suggested earlier?

or instead?

there are nightly process mainly, but users are from different zones (China, US, etc.)

and also there is a process that occurs every 4 hours... (1am, 5am, 9am, ...)

marcus_sommer

To decrease the timeout-settings will help to minimize the risks of running out of memory but then it could happens that the user-experience isn't like before if documents must be loaded into the RAM instead of using the cached document.

I think you should take a look on the QlikView Governance Dashboard to evaluate the min/avg/max RAM consumption over the last month to get a real foundation to decide how much should be the working set settings be and/or to increase the RAM and/or to optimize the tasks and applications.

- Marcus

shayraber
Creator
Creator
Author

just to update-

Infra team added more RAM to the machine (144GB instead of 80GB) as a temporary solution (the current resource was NOT enough obviously).

so far so good, but we need to figure out the proper solution which will be either improving documents, splitting documents, adding a new Server just for users and the current will remain for QVS tasks or upgrading to Sense.

timeout of document doesn't help. i've tried to play and adjust the Min/Max working set which helped also (changed from 50/65 to 70/80-85).

i'll keep updating