Qlik Sense - How to monitor resources using Microsoft Performance Monitor

Bastien_Laugiero — Wed, 10 Feb 2021 14:20:04 GMT

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.

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:

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
Click Add...
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.
Click Next.
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.
Click OK
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.
Repeat for each cluster node.

Re: Qlik Sense - How to monitor resources using Microsoft Performance Monitor

maksim_senin — Fri, 01 Oct 2021 07:37:03 GMT

Hello @Bastien_Laugiero ,

Thank you for that helped to save some time on configuring!

Just one suggestion - does not it make sense to add page file metrics to the counter?

Thank you.

Best regards,
Maksim

Re: Qlik Sense - How to monitor resources using Microsoft Performance Monitor

Sonja_Bauernfeind — Fri, 01 Oct 2021 07:47:36 GMT

Hello @maksim_senin

Not all troubleshooting scenarios are covered in this article, as different issues or monitoring requirements will require different counters, such as when you need to troubleshoot network or disk-related issues.

Adding page file metrics is certainly a good choice if you're looking for additional data.

All the best,
Sonja

article Qlik Sense - How to monitor resources using Microsoft Performance Monitor in Official Support Articles

Qlik Sense - How to monitor resources using Microsoft Performance Monitor

Environment:

Resolution:

Prerequisites:

Setting up a Data Collector:

Related Content:

Re: Qlik Sense - How to monitor resources using Microsoft Performance Monitor

Re: Qlik Sense - How to monitor resources using Microsoft Performance Monitor