How to start investigating Qlik Sense Performance and address high RAM usage

[Andre_Sostizzo]

This article includes two videos that aim to provide guidance for Qlik Sense Enterprise on Windows performance issues and RAM usage concerns. 

Note that even though Qlik Sense is referenced in the video, both Qlik Sense and QlikView share the Qix engine. This means they share performance aspects and the investigation steps and considerations are the same in many scenarios, or at least very similar.

Common root causes of performance issues and high RAM usage are (but not limited to):

• System architecture design 
• Dedicated servers vs. shared 
• Too many concurrent tasks
• Live data reloads in task
• Poorly designed app
• Large apps
• User traffic
• Hardware constraints 

Additional material is provided as Related Content.

Click here for video transcript

Agenda: 

1. RAM configuration setting
2. Troubleshoot High RAM usage
3. Example

Click here for video transcript

Related Content

Referenced in Video: (in order)

• App Metadata Analyzer 
• Synthetic Keys - Qlik Sense on Windows 
• Single and Multi-threading in QlikView and Qlik Sense 
• Qlik Sense Scalability Tools 
• How to enable Qlik Sense QIX performance logging and use the Telemetry Dashboard 
• Telemetry logging - Qlik Sense for Administrators 
• Security Rules and Performance in Qlik Sense 
• Guidance on how to conclude if the issue is Security Rule Related 
• Delay on opening App when section access is used 
• What does "Warning WorkingSet: Virtual Memory is . . . " log line mean? 
• Windows successfully diagnosed a low virtual memory condition 
• Concurrent Reload Settings in Qlik Sense Enterprise  
• How much RAM is consumed per application?  
• QIX Engine Memory Management and CPU Utilization 
• Sense System Performance Analyzer - Qlik Sense for Administrators 
• AAALR is registered in the Qlik Sense logs 
• Antivirus exceptions for Qlik Sense McAfee, Symantec & Other Anti-Virus exclusions required 
• Qlik Sense Share Storage options and requirements 
• Persistence - Qlik Sense for administrators 
• Qlik Sense - How to monitor resources using Microsoft Performance Monitor 
• Hardware Settings For Best Performance With Qlik Sense 
• List of Favorable Server Hardware from Qlik Scalability Center 
• Qlik Sense Performance Benchmark 
• Virtualization Best Practices In QlikView And Qlik Sense 
• How and When to Contact the Consulting Team? 

Related:

• Best Practice for Synthetic keys/Synthetic Tables 
• Qlik Engine Memory Management 
• Qlik Scalability Tools - Qlik Sense for administrators 
• Optimizing app performance - Qlik Sense on Windows 
• Telemetry Dashboard - Admin Playbook 
• Understanding Qlik Sense Performance 
• Video - Qlik Best Practices: Performance and Optimization 
• QlikView and Qlik Sense resource usage and the Qlik Associative Engine Memory Management and CPU Uti... 
• Qlik Engine: Hypercube Memory Limit  
• Error: StdServer: Fiber Loop stall detected 
• Recommended Top-Performing Servers for Qlik Sense and QlikView 
• Qlik Sense® Recommended Product Boundaries 
• Data load editor Data Connections Load Slowly When There is No Internet Connection in Qlik Sense Ser... 
• Qlik Hub takes long time to open after entering credentials. 
• Qlik User Directory Connector task takes significant amount of time to finish 
• Qlik Sense: "Calculation timed out" while loading a chart into an application  
• Qlik Sense: "Out of calculation memory" while loading an application or a chart into an application  
• Qlik Sense: determine memory usage per application 
• Quick tips #8 - Server settings for best performance 
• Generic: Please quantify "performance" 
• Optimizing Qlik Sense Enterprise with Rules  

Environment

• Qlik Sense Enterprise on Windows, all versions

[QFabian]

😁, heavy post, thanks a lot @Andre_Sostizzo 

[vikasmahajan]

Interesting !!

Vikas 

[sandeep1312]

Very Useful and Important.. Thanks a lot @Andre_Sostizzo