Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Digital Support
Digital Support

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.