Qlik Community

Ask a Question

Support Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW

Qlik Sense - How to monitor resources using Microsoft Performance Monitor

Bastien_Laugiero

Qlik Sense - How to monitor resources using Microsoft Performance Monitor


The Microsoft Performance Monitor (perfmon) makes it possible for users to set up automatic data collection jobs which can save data from performance counters at a given interval. This data can, together with Qlik Sense Logs help to analyze Qlik Sense services behavior.
This document describes the steps necessary to save such data using Microsoft Performance Monitor Data Collectors. 

Environment:

Resolution:

 

Note1: These include the Qlik Sense specific and some other environmental counters, but not all counters that may apply to different troubleshooting scenarios. (e.g. Networking, disk read write frequency and speed, etc.)

Note2:
Attached to this article you can find an XML template including the counters below with additional disk and network counters. The template file can be imported in Performance Monitor under Data Collector Sets > right-click User Defined > New > Data Collector Set > Create from a template.

Perfmon Qlik Sense.gif

 

Prerequisites:

 - Microsoft Performance Monitor must be installed on Qlik Sense Server
 - The user which initiates the Data Collectors must be at least local admin

Setting up a Data Collector:

  1. Open Microsoft Performance Monitor (located under Server Manager > Tools)
  2. Open Data Collector Sets in the tree view on the left pane
  3. Open User Defined
  4. Right-click on User Defined and select New > Data Collector Set
  5. Add a value for Name and select option Create manually (Advanced). Click Next
  6. Under Create data logs check Performance counter. Click Next
  7. Click Add...
  8. Expand Processor and select % Processor Time. Make sure that _Total is selected in Instances of selected object:, then click Add >>
  9. Expand Memory and select Available Mbytes, and Committed Bytes, then click Add >>
  10. Expand Logical Disk and select Free Megabytes, then click Add >>
  11. Expand Physical Disk and select %Idle Time, then click Add >>
  12. Expand Qlik Sense Scheduler Service and select every sub item available, then click Add >>
  13. Expand  Qlik Sense Repository Service - Common and select every sub item available, then click Add >>
  14. Expand  Qlik Sense Repository Service - REST API and select every sub item available, then click Add >>
  15. Expand Qlik Sense Proxy service select every sub item available, then click Add >>
  16. Click OK to close the dialog.
  17. Change the Sample Interval to 5. Make sure that Units reads Seconds.
  18. Click Next.
  19. Choose a directory to save the logs in. Click Next.
  20. Make sure that the new Data Collector Set is run with a Local Admin account. Select Save and Close and click Finish.
  21. Select the newly created Data Collector Set in the tree view on the left pane.
  22. Right-click DataCollector01 it in the right pane and select Properties.
  23. Change Log Format to Comma Separated.
  24. Open the File tab and enter a descriptive name for the log file, preferably using the local server hostname convention. In a multi-node environment, this is mandatory to determine which cluster node the logs are from. 
  25. Click OK
  26. Right-click the new Data Collector Set in the tree view on the left pane and select Start
  27. Wait a few seconds and verify that the Data Collector Set are running.
  28. Repeat for each cluster node.
  29.  

Related Content:

Labels (2)
Attachments
Version history
Revision #:
11 of 11
Last update:
2 weeks ago
Updated by: