Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to fix performance problems with Qlik sense server. Qlik is installed in virtual workstation with dedicated memory of 4GB ( some of that will use the operating system so we have about 3GB of memory for Qlik Sense calculation. - for 5 users ) As Qlik apps are getting bigger and more complex the memory usage is going up to 100%. I think that main problem is the growing volume of data being loaded to Qlik. Is there any way how to measure or calculate the volume of data that i am loading from remote SQL servers to Qlik in the virtual machine ?
RAMInitial = SizeOnDisk × FileSizeMultiplier ; this is the initial RAM footprint for any application
FileSizeMultiplier: range between 2-10 (it's a compression ratio depending on the data contained in the app)
RAMperUser = RAMinitial × userRAMratio ; this is the RAM per each incremental user
userRAMratio: range between 1% -10%
Total RAM used per app :
TotalRAM = (RAMperUser × No. users) + RAMinitial
Example:
SizeOnDisk = 1 GB
File Size Multiplier 6 (range is from 2 to 10)
RAMinitial = 1 * 6 = 6 GB
If we take a RAM Ratio per User of 6% then it is 0.06 (range is from 1 to 10)
RAMperUser = 6 x 0.06 = 0.36GB
Then RAM Required for 30 Users
TotalRAM = (RAMperUser × No. users) + RAMinitial
TotalRAM = (0.36 * 30) + 6
TotalRAM = 16.8 GB
found here
https://support.qlik.com/articles/000058871
Regards
RAMInitial = SizeOnDisk × FileSizeMultiplier ; this is the initial RAM footprint for any application
FileSizeMultiplier: range between 2-10 (it's a compression ratio depending on the data contained in the app)
RAMperUser = RAMinitial × userRAMratio ; this is the RAM per each incremental user
userRAMratio: range between 1% -10%
Total RAM used per app :
TotalRAM = (RAMperUser × No. users) + RAMinitial
Example:
SizeOnDisk = 1 GB
File Size Multiplier 6 (range is from 2 to 10)
RAMinitial = 1 * 6 = 6 GB
If we take a RAM Ratio per User of 6% then it is 0.06 (range is from 1 to 10)
RAMperUser = 6 x 0.06 = 0.36GB
Then RAM Required for 30 Users
TotalRAM = (RAMperUser × No. users) + RAMinitial
TotalRAM = (0.36 * 30) + 6
TotalRAM = 16.8 GB
found here
https://support.qlik.com/articles/000058871
Regards
You can even look for optimizing the application by following best practices and removing unused fields, expressions etc. Which can reduce the size of the app and inturn help in reduced RAM utilization.
You can also take help using document analyzers : http://qlikviewcookbook.com/recipes/download-info/qs-document-analyzer/
This most people will be aware but just sharing incase if it was overlooked and keep people reminded.
WoWizer TPM will help you in identifying apps and objects which are having performance issue(RAM/CPU).
Examine App-level CPU/RAM metrics in real time to shortlist those which need Optimization.
You can check out WoWizer TPM product, Below is the link for the same.
Regards,
Nirav Bhimani