Setting up Grafana dashboard to visualize Perfmon logs
Performance Monitor is Microsoft Windows native system monitoring utility. Performance Monitor is installed automatically during Windows setup, and is available by running perfmon.exe
You can setup various counters at various sampling rates, and log the values into a csv file. Just follow the steps here
IN this tutorial, we will setup a simple dashboard to visualize every single performance metrics collected.
a) Influx DB – Open source time series database, for storing Perfmon data b) Influxer – To parse Perfmon data into Influx db c) Grafana – Open source graphing engine and data visualizer
The tools help to visualize the data, and correlate different data points with each other.
Links for tools as of time writing this. Download the latest version of the tools as open source tools change faster.
Place all tools in one folder
Extract files in below zip
- Launch Influx db engine
- Launch Grafana
- Open grafana http://localhost:3000/
- Add influxdb datasource follow grafana guide
Make sure you have Influx process running. Then you can import the perfmon logs directly. If you want to pull every single counter to grafana, its just
Influxer.exe -input "path to csv file"
Import the dashboard templates by saving content of this wikipage to a .json file (Dashboards - > Import)