Many customers would like to view their cluster metrics alongside existing performance data using Prometheus/Grafana
Currently Nutanix does not provide a native exporter for Prometheus to use as a datasource. However we can use the prometheus push-gateway and a simple script which pulls from the native APIs to get data into prometheus. From there we can use Grafana or anything that can connect to Prometheus.
The goal is to be able to view cluster metrics alongside other Grafana dashboards. For example show the current Read/Write IOPS that the cluster is delivering on a per container basis. I’m hard-coding IPs and username/passwords in the script which obviously is not production grade, so don’t do that.
Install the Prometheus Windows exporter from github the installer is in the Assets section near the bottom of the page
Install Prometheus scraper/database to your monitoring server/laptop via the appropriate installer
Point a browser to the prometheus server e.g. :9090
Add a new target, which will be the Windows exporter installed in step.
It will be something like <SQLSERVERIP>:9182/metrics
Ensure the Target shows “Green”
Check that we can scrape SQLserver tranactions. In the search/execute box enter something like this rate(windows_mssql_sqlstats_batch_requests[30s])*60
Put the SQLserver under load with something like HammerDB
Hit Execute on the Prometheus server search box and you should see a transaction rate similar to HammerDB
Install Grafana and Point it to the Prometheus server (See multiple examples of how to do this)
Download the compiled prometheus binaries from prometheus.io
Unzip the binary and cd into the directory.
Run the prometheus binary, from the command line, it will listen on port 9090
$ cd /Users/gary.little/Downloads/prometheus-2.16.0-rc.0.darwin-amd64 $ ./prometheus
From a local browser, point to localhost:9090
prometheus web-ui
Add a collector/scraper to monitor the OS
Prometheus itself does not do much apart from monitor itself, to do anything useful we have to add a scraper/exporter module. The easiest thing to do is add the scraper to monitor OS-X itself. As in Linux the OS exporter is simply called “node exporter”.
Start by downloading the pre-compiled darwin node exporter from prometheus.io