Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Server memory usage per app

Hi,

I want to determine the memory usage of a QlikView app before it is published to our production server. I compared the memory statistics/usage app with the actual memory consumption on our test server (tested this with restarting the QVS service and starting only 1 app) but the results are not the same at all. Below a table with my results:

AppCheckResult (in MB)
App 1File Size100
File Size uncompressed700
Memory usage analyzer app700
Server Memory usage3.800
App 2File Size100
File Size uncompressed200
Memory usage analyzer app200
Server Memory usage1.400
App 3File Size5
File Size uncompressed13
Memory usage analyzer app15
Server Memory usage200
App 4File Size60
File Size uncompressed180
Memory usage analyzer app187
Server Memory usage510

Looking at this table it looks like the memory analyzer app shows just the size of the app when compression is set to Off. Also looking at this table it is almost impossible to determine the server memory consumption before an app is published to this server.

Any thoughts on this? Does anybody know another way to determine the actual memory usage of an app?

Thanks,

Danny

9 Replies

Re: Server memory usage per app

Hi Danny, it's hard to know the RAM consumption as it depends of many factors, some related to the way you create the data model and the relationships.

This app can give you an approximation: RAM Calculation QlikView App

Not applicable

Re: Server memory usage per app

Thanks Ruben. This helps me a little.

But, isn't there a way to analyze the app (like the Memory Statistics app does) so I can determine the memory, the app will consume for 1 user?

Re: Server memory usage per app

What is "memory usage"? Does it include memory for users (each user adds 10% to the memory footprint)? Does it include the cache extension and QVS overhead? Does it include the growth caused by the reload of ever growing source tables?

The optimal calculation of memory requirements is largely based on estimates (see Ruben's suggested document), experience and continuous run-time measurements. It's not an exact science, unfortunately.

Peter

Re: Server memory usage per app

Maybe some if this posts gives you more info to analyze:

- Recipe for a Memory Statistics analysis

- Document Analyzer V2 -- a major update

Gencho
Contributor II

Re: Server memory usage per app

Hi

The usage of the memory ram I think is variable because depend of the server, for example if the server is virtual, the process that windows have or if you have another tools running in the server.

Also the performance can change depending of your bios settings, I share you some information this topic

Quick tips #8 - Server Settings For Best Performance

Check the app that I share you, can be useful for you

image.png

Regards

Re: Server memory usage per app

I'm not sure what tool you were using as the "Memory Usage analyzer app", but it could be that is was calculating space for the data only, and not the sheet objects.

Document Analyzer

Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

does a fair job of calculating what is called the "RAM Footprint" on the Summary sheet, which includes both the data and the sheet objects. It also identifies the per user increment on the Memory sheet.

Note that as soon as you open a document in QVS, results start getting added to the cache. So just looking at QVS memory in task manager is not an accurate measure of the baseline needed for an app. However, I think it's still a useful number because your app will need some cache when it's actually used -- so I think using actual QVS memory for planning make some sense.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Not applicable

Re: Server memory usage per app

Thanks for your answer. I used the Document Analyzer for app number 2 (in my overview above) and the RAM footprint result is 230MB. This differs a lot with the memory usage on the server (1.400MB). Is this caused by 1.100MB of results in cache then?

Any idea how to get better memory analyzing results?

Thanks,

Danny

Re: Server memory usage per app

What version of Document Analyzer?

Not applicable

Re: Server memory usage per app

The latest version from your link, version 2.6!

Community Browser