Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
jli87
Partner - Contributor II
Partner - Contributor II

System Recommendation

Hi All, 

I am kind of new to the system admin side of Qlik and was hoping to get some help. I am running into performance issues when the physical memory usage is at 98% and the CPU usage is around 50-60%. The current environment is CPU @2.30 GHz (2 processors) and 32GB of RAM. Is it reasonable to think that upgrading it to 64GB of RAM would relieve this issue of performance?

Thank you,

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Yes, you will probably need to do something about your RAM, but I would also consider adding cpus to my environment. In the system requirements it says QlikView requires multicore compatible processors, but my experience that you need at least 4 processors to ensure a good stable environment.

To summarise. Double the RAM double your processors. If that is not enough the add some more ram to your system.

A paralell activity is to identify the heavy ram consuming qv documents to see if you can optimizer it in some way. Tools like Governance dashboard and Document Analyser could be helpful to identifying apps and pinpointing document areas to improve. 

Good luck

View solution in original post

2 Replies
Vegar
MVP
MVP

Yes, you will probably need to do something about your RAM, but I would also consider adding cpus to my environment. In the system requirements it says QlikView requires multicore compatible processors, but my experience that you need at least 4 processors to ensure a good stable environment.

To summarise. Double the RAM double your processors. If that is not enough the add some more ram to your system.

A paralell activity is to identify the heavy ram consuming qv documents to see if you can optimizer it in some way. Tools like Governance dashboard and Document Analyser could be helpful to identifying apps and pinpointing document areas to improve. 

Good luck

Brett_Bleess
Former Employee
Former Employee

You may also want to check out the Scalability area of Community too:

https://community.qlik.com/t5/Qlik-Scalability/gh-p/qlik-scalability

And here are a couple of Help links as well that may prove useful:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/LoadData/best-p...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/application-per...

And one other post regarding how the QIX engine uses Memory and CPU:

https://community.qlik.com/t5/Qlik-Support-Knowledge-Base/QIX-engine-memory-management-and-CPU-utili...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.