RAM Usage in QlikviewServer

[Anonymous]

Dear All,

I have few queries regarding server RAM Usage as our server RAM utilization is gradually increasing.

we are using Qlikvew 11.2 and we do not have publisher.

We are having 5 dashboards deployed in server altogeather the size of the all Dashboards are less than 20 MB. and we are having users around 40. But concurrent users are less than 10.

we are having 8 GB RAM. which is quite sufficient when I calculate the required RAM using "Qlikview Server RAM Calculator spread sheet".

Follwing are the Clarifications I wanted to understand.

1. Does QV server load All the Dashboards to RAM which ever is available in User documents mapping folder even though users are not using? or Only Loads the QVWs to RAM which are opened by users currently?

2. what is Minimum RAM required to run the Qlikview Enterprise server service(without single QVW in server, which menas emty setup of QV server)?

3. With our 5 QVWs , we may requied less than 400 MB RAM(calculated based on RAM Calculator). But why our server is consuming more than 3 GB ? (Last month RAM Consumption was 2 GB and this Month it is 3 GB.)

4. Recently we have setup the LDAP (earlier we are using custom Authentication). After that I can see the RAM Usage more(Analyzed using Governance Dashboard)?

5. Most Importent thing I want to know is , How do I Know In detail usage of my 3 GB consumption of RAM? Is there any utillity available to analyze this?

Please find the below capture of RAM Usage from System Monitor Utility.

Many Many Thanks in Advance...

Best Regards,

Chinna

[Bill_Britt · Accepted solution]

HI,

1. Does QV server load All the Dashboards to RAM which ever is available in User documents mapping folder even though users are not using? or Only Loads the QVWs to RAM which are opened by users currently? No, only when the document is open.

2. what is Minimum RAM required to run the Qlikview Enterprise server service(without single QVW in server, which menas emty setup of QV server)? Somewhere around 6-8 meg

3. With our 5 QVWs , we may requied less than 400 MB RAM(calculated based on RAM Calculator). But why our server is consuming more than 3 GB ? (Last month RAM Consumption was 2 GB and this Month it is 3 GB.)

Lets look at this. Look at the closed size of the QVW and lets say it is 100mb. When it is open on server it will grow by So, server memory will be around 400mb. For each users that comes into the document the memory will grow by 10% . S, if you have 10 users that would be 400mb. So, the open document memory would be 800mb. Now this does take into the users click as they go through the document. With that you will see the memory spike as users use the qvw. Also, as more data is added to the QVW the memory will grow.

4. Recently we have setup the LDAP (earlier we are using custom Authentication). After that I can see the RAM Usage more(Analyzed using Governance Dashboard)? Yes, the LDAP information is cached.

One thing you have to watch for is poorly designed QVW. This could be the backend or dashboard design, if not done properly they can use a lot of memory.

Bill

[Anonymous]

Thank you Bill...

Hope this thread will be helpful to others to get clarifications.

Once again Thank you all for your valueble inputs

Best Regards,

Chinna