How to set up performance monitoring for QlikiIew server service to identify resources issues on a QlikView Server.
For instruction on how to set up perfmon for QlikView Distribution
service (QDS) see this QlikView - How to log CPU and memory with Microsoft Performance Monitor on a windows 2012 Server (Pe...
Resolution
Instructions for how to use Windows Performance Monitor to log resource utilization on a QlikView Server server.
- Start Windows Performance Monitor and navigate to Data Collector Sets – User Defined.
- Right-click in the right-hand pane and select “Create new” - “Data Collector Set”, label accordingly and select “Create manually”, then “next”
- In the next screen select “Create data logs” and select “Performance counters and then press “next”
- In this step, you will select the performance counters relevant to the investigation at hand. In this case, we are trying to troubleshoot QlikView Server performance, so we select according to the screenshot:
- Then press “Ok”
Next screen lets us select the sample interval, and we want relatively granular data so we set 5 seconds. Then press “Next”
- Next step is to select where to store the data logged. I accept the default location and press “Next”
- Then select “Save and close” and “Finish”
- Then double-click on the newly created Data Collector set.
- And the last step is to right-click on the name of the data collector set we have just created and select “Start”
Leave the collector set running until the issue has been reproduced, remember to record timestamps for the issue so we can correlate against recorded server performance at that time.
When the issue has been reproduced, Qlik Support wants the time stamp for the issue, the user name for the user that encountered the issue, the Data Collector log file in .csv format and all the QlikView server logs.