Pmm 3 and sqlserver

Percona Monitoring and Management (PMM) PMM 3.x
1

Hello,

I would like to monitor some mssql databases in PMM.
I installed an exporter: awaragi/prometheus-mssql-exporter and can access to the metrics of my mssql db : http://vtldtbpmm101:9187/metrics

Is there a way to graph this data in pmm3 ?

Thanks for any help

Regards

2

Yes, but it will be convoluted to do. The simplest way is probably to install vmagent on the same machine as mssql, and configure it to both 1) scrape the metrics of the exporter, and 2) remote write/forward metrics to PMM. You’ll probably need a Service Account from PMM to authorize vmagent to write data to the API.

Since Windows isn’t a support operating system, the above is a best-guess/untested solution. Feel free to post your success for others to enjoy!