Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
MalcolmCICWF
Contributor II

Qlikview not releasing Memory?

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?

Capture.JPG

1 Solution

Accepted Solutions
MVP
MVP

Re: Qlikview not releasing Memory?

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

2016-02-28 #1.PNG

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...

View solution in original post

11 Replies
bnichol
Valued Contributor

Re: Qlikview not releasing Memory?

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

Partner
Partner

Re: Qlikview not releasing Memory?

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,

MVP
MVP

Re: Qlikview not releasing Memory?

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

2016-02-28 #1.PNG

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...

View solution in original post

Re: Qlikview not releasing Memory?

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
Contributor II

Re: Qlikview not releasing Memory?

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

MalcolmCICWF
Contributor II

Re: Qlikview not releasing Memory?

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

Re: Qlikview not releasing Memory?

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

Re: Qlikview not releasing Memory?

Antivirus scans / updates can often consume loads of CPU.

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

MalcolmCICWF
Contributor II

Re: Qlikview not releasing Memory?

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.