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.
##2. Download tools Links for tools as of time writing this. Download the latest version of the tools as open source tools change faster.
-
Grafana https://grafanarel.s3.amazonaws.com/winbuilds/dist/grafana-2.1.3.windows-x64.zip
-
InfluxDB https://github.com/AdysTech/Influxer/releases/download/v0.0.1.1/influxd.exe
-
Influxer https://github.com/AdysTech/Influxer/releases/download/v0.0.1.1/Influxer.exe https://github.com/AdysTech/Influxer/releases/download/v0.0.1.1/influxdb.conf
Place all tools in one folder
Extract files in below zip
- Initial setup tools 3.1 Launch Tools
- Execute “Launch Influx”
- Execute “Launch Grafana” 3.2 Create grafana User
Grafana uses a separate user name for accessing Influx DB. Update below URL with username and password, copy paste to a browser http://localhost:8086/query?q=CREATE+USER+test1+WITH+PASSWORD+%27test123%27 3.3 Setup data source in Grafana
-
Open grafana http://localhost:3000/
-
Add datasource (update the dbname (you will use it in next section as well), username and password used in 3.2)
-
Import Perfmon logs
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 -influx http://localhost:8086 -dbname somedbname-tags "application=appname" -input "path to csv file"
- Setup dashboard Import the dashboard templates provided along with this document (Dashboards - > Import)