Qlikview not releasing Memory?

[MalcolmCICWF]

I have noticed over the recent months as more and more users are using reporting, that our CPU usages is always in above 60%. I have also noticed that when Management console shows nobody actively using reporting during slow or after hours, that CPU usage remains high.

In the MC, where it shows open documents, but sessions using them, does that mean they are still in memory? If so how long?

Has anyone else noticed anything like this?

[bnichol]

Jeremy,

The documents you identified with no session are still in memory.  Even after these document are removed from the open documents list they are still in memory.  Only when your QVS's memory consumption approaches the working set thresholds or after a long duration of inactivity will the memory be released.

This is a constant complaint of mine for the QVS.  The working set values, which provide to help you control memory consumption, work better than historically.  Still, I'd expect the garbage collection processes to be much more proactive.

In the past, some QV Admins I've talked to would restart the QVS regularly to eliminate potential issues due to poor garbage collection.  

It would be nice if there were a set of administrative setting, that would assist in better controlling when and how memory is reclaimed.

Regards,

B

[mithilesh17]

Hi Jeremy,

Yes they are still in memory. What we do in this scenario is restart QVS service when there is no user accessing the report, which you can find out by Documents and Users tab.

Regards,

[petter · Accepted solution]

There is a setting that can be adjusted for the "Document Timeout" for the server as a whole:

The help for this page says:

_______________________________________________________________________

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.

_______________________________________________________________________

8 hours after last session has ended for a particular document before it is discarded from memory - that is a pretty long time usually...

[Peter_Cammaert]

The otther thing you are wondering about (but which doesn't seem to be part of your actual question) is CPU usage remaining above 60% even when noone is using any document (all documents showing 0 sessions in QMC, right?) In that case, you could use Task Manager to figure out what process is doing all this hard work.

My guess is that it may be the distribution service that is doing one or more reloads. If it isn't reloads, it may be QVS that is dealing with a document with a sub-optimal data model. At least that was what I got a while ago: CPU going to 100%, no response in the AP and a user trying to open new sessions that were all getting stuck without any means of recovery except for restarting the QVS service.

[MalcolmCICWF]

Yes I have had it where nobody had a session in call, but CPU showed at above 60%, with no reloads happening.

[MalcolmCICWF]

Thanks, I have ours set to 60 minutes... not sure if it should be even lower

[Peter_Cammaert]

Did you check with Task Manager what process is hogging your server cpu?

[Anonymous]

Antivirus scans / updates can often consume loads of CPU.

But as Peter suggests find out what process[es] is/are to blame.

[MalcolmCICWF]

When we have looked it just showed the QV Server, but nothing was reloading or open. It MAY be the documents in memory as stated above though. I am going to attempt to drop the document open time from 2 hours down to 30 minutes.