Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have qlikview server and publisher installed on a machine and we have four other nodes with 196 GB memory each. On one of the nodes we have two customers and sometimes the memory usage reaches to 190 GB. My questions are
1) How to check the reason for the memory usage?
2) If the memory usage increase is because of caching, is there any solution for it? for example, set some caching settings so that it deletes previous cache and load new one so that the memory consumption does not reach high
3) When is the time when I should be left with only option to add more ram to the clusters?
Shah
Actually in a Server+Publisher environment, there are two causes of high memory usage:
When you combine the two (intra-day reloads), and your memory usage reaches the upper limit, either one of them may fail to execute or to respond.
Check the size of your QVW applications. In desktop, load them with all data and store them on disk uncompressed. This will give you an indication of how much RAM they'll be using. Add 10% for every user that opens the same model. The community has lots of information and documents on how to calculate memory requirements for a QlikView server setup.
Peter
Oh and BTW which version of QVS did you install? Some older releases experienced lockups due to memory exhaustion when users started doing specific things in the AccessPoint.
Hello
You can limit QlikView Server resources consumption by QMC: System - QlikView Servers - your server - Performance. Look at Working set block. These are the RAM usage range settings. When consumed RAM is near High value, QVS starts to delete older cache.