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.
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.
- 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:
Open Microsoft Performance Monitor (located under Server Manager > Tools)
Open Data Collector Sets in the tree view on the left pane
Open User Defined
Right-click on User Defined and select New > Data Collector Set
Add a value for Name and select option Create manually (Advanced). Click Next
Under Create data logs check Performance counter. Click Next
Expand Processor and select % Processor Time. Make sure that _Total is selected in Instances of selected object:, then click Add >>
Expand Memory and select Available Mbytes, and Committed Bytes, then click Add >>
Expand Logical Disk and select Free Megabytes, then click Add >>
Expand Physical Disk and select %Idle Time, then click Add >>
Expand Qlik Sense Scheduler Service and select every sub item available, then click Add >>
Expand Qlik Sense Repository Service - Common and select every sub item available, then click Add >>
Expand Qlik Sense Repository Service - REST API and select every sub item available, then click Add >>
Expand Qlik Sense Proxy service select every sub item available, then click Add >>
Click OK to close the dialog.
Change the Sample Interval to 5. Make sure that Units reads Seconds.
Choose a directory to save the logs in. Click Next.
Make sure that the new Data Collector Set is run with a Local Admin account. Select Save and Close and click Finish.
Select the newly created Data Collector Set in the tree view on the left pane.
Right-click DataCollector01 it in the right pane and select Properties.
Change Log Format to Comma Separated.
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.
Right-click the new Data Collector Set in the tree view on the left pane and select Start
Wait a few seconds and verify that the Data Collector Set are running.