topic Re: QVS Memory usage -> Daily restarts of QVS service in QlikView

QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Mon, 26 Jan 2026 18:19:17 GMT

QV 11.20.12235.0

Windows Server 2008 R2 SP1

X64

Memory: 28GB

3x Xeon EON E5530 2.4GHz

10 users

10 QVW documents

<500,000 records

------------------------

We are daily running through the memory ceiling of our QlikView 11 server, with the QVS consuming 70-80% of available memory. At that point, users are kicked off and unable to reconnect as memory utilization keeps growing. It's not until we stop and restart the QVS service that normal operation is restored. This happens every 18-24 hours.

We only have 10 users and 10 QVW documents. I have previously worked in a 250-user QlikView environment with 8 quad core processors and 128GB memory - same problem.

Does anyone have any recommendations to resolve this problem?

If there isn't a solution to this unsustainable daily operational issue and memory 'leak' maybe it is time to finally look at a competitor solution.

After 4 years of using QlikView, I love the product, but can't believe Qlik hasn't found a sustainable solution to this memory issue.

Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Tue, 20 May 2014 19:54:02 GMT

Three restarts of the QVS service so far today.

Re: QVS Memory usage -> Daily restarts of QVS service

fkeuroglian — Wed, 21 May 2014 01:51:18 GMT

Hi, what size have the documents?

do yo always have all the documents in the same server?

it is a new problem, or always happend this before?

Re: QVS Memory usage -> Daily restarts of QVS service

Alejandro_Hernández — Wed, 21 May 2014 02:15:48 GMT

Hi Klaus

Unfortunately there's no simple answer to your problem.

There's a lot of points to check because the amount of records doesn't really say much. For example, what kind of data are you loading? How efficient is your data model? What kind of calculations are you doing in the UI? What charts do you have and how are you using them?

As you can see there are many variables at play that can make it seem like a memory leak.

The following links will help better understand the issue, but my best recommendation is to let a Qlik consultant assess the situation and help you find a solution.

http://www.qlik.com/us/~/media/Files/resource-library/global-us/direct/datasheets/DS-Technical-Brief-QlikView-Server-Mem…

http://www.qlik.com/us/~/media/Files/resource-library/global-us/direct/datasheets/DS-Technical-Brief-QlikView-Architectu…

QlikView Scalability Overview | Qlik

Re: QVS Memory usage -> Daily restarts of QVS service

Ronnie_Taborn — Fri, 23 May 2014 13:17:05 GMT

Do you have SQL on the same server? Please post the QVS logs and that will give you an idea about the memory issue. It could be your shared file. Are you using Plugin. Make all your users are on the same version as the server. What version of QlikView are you on?

Re: QVS Memory usage -> Daily restarts of QVS service

Fri, 23 May 2014 13:20:37 GMT

I am aware of cases where this has impacted clients to the point of having to revert to QV10 to stop the memory burn..

Re: QVS Memory usage -> Daily restarts of QVS service

Colin-Albert — Fri, 23 May 2014 13:23:25 GMT

How frequent are your reloads? It could be that there is insufficient RAM to support your users accessing the applications, and also running the reload process running during the day.

I would suggest running an app to view your QV logs and see what RAM is consumed when your reloads run without users accessing the applications, and then how much ram is consumed by user access. This may help identify if the issue is in optimising your load scripts, optimising your chart expressions, or even simply changing your reload schedule.

Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Fri, 23 May 2014 13:38:59 GMT

The documents are no more than 100MB each. There are 12 QVW's.

They are all on the same server.

This is not a new problem, but it has gotten worse in the past month after we increased the frequency of the reloads.

Re: QVS Memory usage -> Daily restarts of QVS service

preminqlik — Fri, 23 May 2014 13:42:55 GMT

i think after users logout from the session , the memory from the ram is not releasing , once check , active users when users logged in and all users logged off..

Re: Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Fri, 23 May 2014 13:48:08 GMT

Do you have SQL on the same server?

Please post the QVS logs and that will give you an idea about the memory issue. It could be your shared file.

See attached.

Are you using Plugin.

Make all your users are on the same version as the server. What version of QlikView are you on?

Both server and clients are on the same version: QV 11.20.12235.0.

Re: Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Fri, 23 May 2014 13:51:55 GMT

How frequent are your reloads? It could be that there is insufficient RAM to support your users accessing the applications, and also running the reload process running during the day.

We have 12 QVWs. 5 reload daily. 6 reload every hour (simple dashboards with max three charts that pulls performance metrics) and one (our main QVW) reloads every 30 minutes.

We are using the Governance Dashboard. I will analyse this closer based on your troubleshooting recommendations.

Thank you.

Re: Re: QVS Memory usage -> Daily restarts of QVS service

Ronnie_Taborn — Fri, 23 May 2014 13:55:22 GMT

2014-05-15 03:21:32

2014-05-15 13:17:53

500

Warning

WorkingSet: Virtual Memory is growing beyond parameters - 19.436(16.800) GB

Possible resolutions:

limit the amount of concurrent sessions allowed
develop the application(s) for optimal memory footprints
reduce the amount of Publisher/Server task reloads
limit application development on the server
free up resources by disabling other applications
increase your hardware resources

2014-05-09 17:01:23

2014-05-12 12:14:22

300

Error

Session Recovery Failed: An exception (T) occured during create $LASTKNOWNSTATE on document D:\QLIKVIEW\ACCESSPOINT\PATH VOLUME.QVW.

This error message is about file handling and often related to shared files.

When QlikView logs out an error into the Events file, it should display the entire error message as a consequence of the exception that has been caught, in the program.
However, some cases in 11.20 SR4 or 11.20 SR5, it just display the first character of the error message in stead of displaying entire error message.

Typically, you can only see a capital T, which does not tell that much about the actual error.

Example: An exception (T) occured during open of Test.qvw

It was intended to show those messages in parentheses.

The file cannot be opened

The file doesn't exist

Upgrade to 11.20 SR6. The issue has been fixed.

Re: Re: QVS Memory usage -> Daily restarts of QVS service

Colin-Albert — Fri, 23 May 2014 14:05:28 GMT

The 6 tasks that reload every hour, do these all reload at the same time, or can their reloads be staggered ? Could you trigger each of these 6 so each one runs after another has completed?

This will reduce the impact of running all 6 at the same time.

Re: Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Fri, 23 May 2014 14:24:00 GMT

The 6 frequent reloads are all staggered.

They run for 1-5 minutes each and never at the same time.

Re: QVS Memory usage -> Daily restarts of QVS service

markodonovan — Tue, 27 May 2014 12:15:29 GMT

Hi Klaus,

If you are using publisher you could look into moving it to a new server if possible.

This is what we have done here for free some RAM.

Here is some info on how to move publisher:

Re: Publisher install in different machine

Thanks

Mark

http://www.youtube.com/practicalqlik

Re: QVS Memory usage -> Daily restarts of QVS service

Wed, 28 May 2014 14:02:13 GMT

Klaus,

A Couple of ideas, that have helped me.

There is a server option to allow only one copy in memory at a time, this needs to be set if you are doing frequent reloads, and users are connected for long sessions.

also set the qlikview documents parameter

"Refresh Mode when document is Updated on Server" to

"Server performs refresh automatically without any client action"

Does the increase in memory coincide withthe reload of documents?

How much space do the documents take straight after reload without anyone using them? does the memory utilisation increase rapidly as the users start to use the applicaitons?

Richard

Re: QVS Memory usage -> Daily restarts of QVS service

Ricardo_Gerhard — Wed, 28 May 2014 14:34:59 GMT

Qlikview is a in-Memory produtc, but exists a lot of config to avoid this issue.

I work with Qlikview more than 2 years only in infrastructure scenarios and all tunned servers working fine WITHOUT REBOOT TASKS.

The default installation is a poor config. There are a lot of configs in QMC, documents and files.

Re: QVS Memory usage -> Daily restarts of QVS service

rwunderlich — Wed, 28 May 2014 14:40:00 GMT

It's normal for QVS to use 70-80% of memory, as it will fill it with cached results. This is not a leak. However, you mention that users are experiencing instability so somethings not right. Look in the QVS event log to see if there is an error message for the users being terminated or denied access. Also look for log "Working Set..." messages.

There were some QVS memory fixes on SR6. Are you using Preload by chance?

-Rob

Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Mon, 02 Jun 2014 15:37:05 GMT

Thanks, Richard.

I have changed the setting to 'allow only one copy in memory' and will see how that affects users, memory utilization and performance.

"Refresh Mode when document is Updated on Server" is already set to

"Server performs refresh automatically without any client action"

The memory utilization increases gradually throughout the day with usage and reloads. We have had increased usage and increases to the number of reloads through the day, so it's difficult to point to which one is the main reason.

We have had very little changes to the actual QVWs, but can't rule out ineffective scripts, which will be our next priority.

Thanks again for taking the time to respond.

Re: QVS Memory usage -> Daily restarts of QVS service

klaus_feldam — Mon, 02 Jun 2014 15:43:09 GMT

Thanks, Rob.

Very helpful.