Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
klaus_feldam
Creator II
Creator II

QVS Memory usage -> Daily restarts of QVS service

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.

29 Replies
klaus_feldam
Creator II
Creator II
Author

Three restarts of the QVS service so far today.

fkeuroglian
Partner
Partner

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?

Alejandro_Hernández

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

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

QlikView Scalability Overview | Qlik

Ronnie_Taborn
Support
Support

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?

Not applicable

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

colin_albert

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.

klaus_feldam
Creator II
Creator II
Author

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.

preminqlik
Specialist II
Specialist II

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

klaus_feldam
Creator II
Creator II
Author

Do you have SQL on the same server?

No

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.

No

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.