Use Cases

Manage Qlik App Slowness during Peak usage times
#

Challenge: Users are accustomed to fast Qlik dashboards. Slow dashboards, inability to load large apps, extended reload times, and session timeouts during peak times such as Monday mornings or month end upset these expectations.

Wowizer TPM Solution:

  • Real-time Performance Insights: CPU utilization, memory usage, app response times in real-time allowed Qlik champion to pinpoint performance bottlenecks as they occurred and the root cause behind them.
  • Reload Optimization: By analyzing the performance data, Qlik champion identified apps and tasks that were consuming excessive resources and rearranged reload tasks in timeframe.
  • Load Balancing: Wowizer TPM provided node level and app level CPU and RAM visibility in real time enabling smart load balancing for Qlik Sense cluster.
  • Alerting and Proactive Management: Wowizer TPM sent alerts to the Qlik champion whenever performance thresholds were exceeded. This proactive approach allowed Qlik admins to take action such as killing some reload tasks to prevent downtime and performance degradation.

Outcome:

  • Cost Saving with Higher Adoption: Availability of stats allowed Qlik Champion to know the exact solution and present it to the management, getting immediate approvals. This improved performance and ability to load large apps. It not only improved user experience but also helped drive higher adoption.
  • Alerting: Allowed the Qlik champion be worry free.

Random unexpected Performance degradation #

Challenge: Qlik suddenly started having slowness and high error count, even during slack times for no reason and no change being made on Qlik side.

Wowizer TPM Solution:

Wowizer TPM’s comprehensive monitoring keeps track of significant events. The Qlik Admin identifies that there was a Windows Update notification in Wowizer TPM and the change in error count and slowness are correlated with the timing of the Windows Update.

With Wowizer TPM correlation, the Qlik Admin has basis to request IT and roll back the Windows update. The performance of Qlik Sense is restored to its previous optimal state. 

Outcome:

  • Smart Correlation: Wowizer TPM allowed root cause identification with smart correlation
  • Minimal Downtime: Rolling back the update promptly minimized downtime and improved confidence in Qlik and the Qlik team.
     

Windows Updates are routine and normally do not affect Qlik. However ability to quickly identify when one of them causes unusual behavior was of immense value.

Manage unused Apps with Wowizer TPM #

Challenge: Like most organizations, large number of Qlik Sense apps were build over time. Many of these apps are no longer actively used, leading to wasted disk space and governance overhead. However decommissioning needs historical usage data over a period of time.

Wowizer TPM Solution:

Usage frequency with resource footprint: Wowizer TPM offers a comprehensive view of Qlik Sense app usage and system performance metrics. Wowizer TPM can identify apps that have remained dormant for extended periods. Qlik champions can prioritize apps with barely any usage and high resource footprint

Outcome:

  • Cost Saving on Resources: Identifying that the user was rarely using a very small part of large app which was consuming lot of resources for reload and use, helped improve performance by pruning the app. Administrators choose to delete or archive large unused apps
  • Governance overhead reduction: Reduced documentation for unused apps was the cherry on the top!

Wowizer TPM capabilities in app usage analysis, disk space monitoring improved system performance, cost-effectiveness and reduced governance overhead substantially.

Balancing Qlik Sense Cluster with Wowizer TPM #

Challenge: Some Qlik nodes were consistently overloaded, while others remained underutilized. Deciding whether to add more nodes or redistribute reload tasks and apps to maintain performance had become a daunting task.

Wowizer Solution:

  1. Real-time Node Monitoring: Wowizer TPM provided node level real-time visibility into the performance metrics- CPU, RAM as well as the reload task distribution.
  2. Load Distribution Analysis at Peak time: By continuously analyzing the distribution of user queries and app reloads, Wowizer TPM identified nodes that were struggling to keep up with the workload and those that had spare capacity at peak time.
  3. Task-Level Insights: Wowizer TPM drilled down to the task level, offering insights into how individual reload tasks were affecting node performance.
  4. Alerts: It also triggered alerts when nodes approached resource saturation or when task queues grew too long.

Outcome:

  • Optimized Node Performance for Peak load: Wowizer TPM’s insights allowed the Qlik team to distribute tasks to take care of the peak load time to ensure best user experience while still managing the reloads.
  • Cost efficient Resource Planning: Once all balancing was done and all nodes were still substantially loaded, it was easy to make a case for an additional node confidently.
  • Enhanced User Experience: Wowizer TPM’s real-time alerts helped Qlik team to proactively make adjustments before potential system performance degradation.

Leveraging Wowizer TPM Feedback Collection Extension for Enhanced User Experience #

Challenge: Qlik champions have to be at the receiving end of any performance or access issues faced by end users. However, not knowing the exact time of the issue when they are raised in monthly meetings is a challenge as barely anything can be done about them!

Wowizer TPM solution:

  1. Real User Perspective with time: Valuable insights directly from your users giving understanding of when the user is facing the issue
  2. Correlation of feedback with Metrics: Wowizer TPM’s real time data and feedback overlay on chart helps you identify what exactly was happening in terms of the CPU/RAM/sessions/reload and other aspects of the app when the user reported the issue.

Outcome:

Early issue resolution with Context: Knowing the context and other metrics at the time of feedback helps resolve the issue much faster.

Enhanced User Satisfaction: Actively seeking and acting upon user feedback underscores Qlik team’s commitment to user delight.

Effective Prioritization of development/optimization: Armed with user feedback, Qlik champions can prioritize performance issues based on their real-world impact. This approach ensures that your development/optimization efforts are directed towards addressing the most critical problems that significantly affect user productivity and data analysis.

Updated on October 23, 2023