RAM usage by users won't release

[shayraber]

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

[Gysbert_Wassenaar]

Try lowering the document timeout setting.

From the help file:

Documents

On the Documents tab, the settings for document control can be managed.

Server

Document Timeout

Open documents take up valuable system resources (that is, memory space, RAM, is allocated) and should not be allowed to remain open when not in use. However, if a document is closed too quickly, the users may get longer delay times when accessing the document, because the server has to reopen it. This value controls for how long a document will be allowed to be unused before the QlikView Server (QVS) closes the document and reclaims the resources.

Default value: 480 minutes.

[berkarmagan]

Just try to change your document timeout settings which located on QMC->Documents->Your QVD->Server->Performance. Hope it helps you.

[shayraber]

hi Gysbert,

i'll give it a try...

but, something i noticed now -

doesn't it suppose to free the RAM that was in use?

[Gysbert_Wassenaar]

If you use Qlikview Desktop to open and then close a document then the memory will be released immediately. Qlikview Desktop when used stand alone (i.e. not with open in server) doesn't use Qlikview Server and won't have any effect on the memory usage of Qlikview Server.

[agomes1971]

Hi,

the RAM is not managed by the QV Server is managed by OS.

My advice is to do a restart at least once a week.

Regards

André Gomes

[adamdavi3s]

No the documents are held in memory until they timeout so you will see a drop in RAM usage of around 10% of the document size (in RAM) when a user disconnects, but the main data remains in memory.

My rule of thumb is generally:

Document size * 10 = RAM requirement + 10% for each user logged on

[berkarmagan]

Yes but, if anyone on session, click on aything hard to calculate ram will increase and hovewer that user closed document, qlik will try to calculate on server side so ram wont decraese on this scenierio.

[shayraber]

The fact that the desktop is not effecting the memory used by the server is known to me.

what I'm trying to figure out is why, when user closes the document and exits the access point - the RAM used by him doesn't releases...

now, when no task is running, when num of users is about 5 users the RAM usage is around 50GB...

[adamdavi3s]

Ok expanding on my answer below my understanding is something like this:

1gb document

User opens it > 10gb Ram is used

Next user opens it > 1gb of Ram is used

One user closes it> RAM drops 1gb

Next user closes it > no drop in ram

document timeout hits limit > Ram drops to 0