# How to configure PMM Invetory for MSSQL

**URL:** <https://forums.percona.com/t/how-to-configure-pmm-invetory-for-mssql/32905>\
**Category:** PMM 2.x\
**Created:** [September 4, 2024, 8:54am UTC](https://forums.percona.com/t/how-to-configure-pmm-invetory-for-mssql/32905 "2024-09-04T08:54:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Marek\_Pastier](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marek_pastier/32/16559_2.png) [@Marek\_Pastier](https://forums.percona.com/u/Marek_Pastier)\
**Post date:** [September 4, 2024, 8:54am UTC](https://forums.percona.com/t/how-to-configure-pmm-invetory-for-mssql/32905/1 "2024-09-04T08:54:39Z")

</div>

## Description:

I started windows\_exporter-0.28.1-amd64.exe on windows sql server.  
`.\windows_exporter-0.28.1-amd64.exe --collectors.enabled "cpu" ts=2024-09-04T08:56:47.079Z caller=exporter.go:216 level=info msg="Running as adm" ts=2024-09-04T08:56:47.085Z caller=exporter.go:223 level=info msg="Enabled collectors: cpu" ts=2024-09-04T08:56:47.085Z caller=exporter.go:258 level=info msg="Starting windows_exporter" version="(version=0.28.1, branch=HEAD, revision=9febf1e97cc691bb9a29ca6cc69b132e7772acec)" ts=2024-09-04T08:56:47.085Z caller=exporter.go:259 level=info msg="Build context" build_context="(go=go1.22.6, platform=windows/amd64, user=runneradmin@fv-az1388-522, date=20240831-17:41:07, tags=unknown)" ts=2024-09-04T08:56:47.086Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9182 ts=2024-09-04T08:56:47.086Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9182`

Result from [http://testsql:9182/metrics](http://testsql:9182/metrics)

```auto
# HELP go_gc_duration_seconds A summary of the wall-time pause (stop-the-world) duration in garbage collection cycles.
# TYPE go_gc_duration_seconds summary
go_gc_duration_seconds{quantile="0"} 0
go_gc_duration_seconds{quantile="0.25"} 0
go_gc_duration_seconds{quantile="0.5"} 0
go_gc_duration_seconds{quantile="0.75"} 0
go_gc_duration_seconds{quantile="1"} 0.000997
go_gc_duration_seconds_sum 0.000997
go_gc_duration_seconds_count 23

```

I tried over GUI PMM create external service Inventory / Add service / Step 2 of 2  
where External service endpoint is my url link. [http://testsql:9182/metrics](http://testsql:9182/metrics)

Service has been created success but I have Monitoring status “Failed”. I don’t know where is the problem. In structure generate by windows\_exporter or my config.

Thx for all tipes

---

<div class="post-metadata">

**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\
**Post date:** [September 5, 2024, 9:34am UTC](https://forums.percona.com/t/how-to-configure-pmm-invetory-for-mssql/32905/2 "2024-09-05T09:34:49Z")

</div>

Hi @Marek_Pastier  
“Failed” status is Ok in this case, as you have an External Exporter, and we can’t correctly detect its status.  
Please see the [PMM To monitor `pgpool` using `pgpool2_exporter` - #3 by Roma\_Novikov](https://forums.percona.com/t/pmm-to-monitor-pgpool-using-pgpool2-exporter/32878/3) for some explanation.  
But in your case, search for some “windows\_” metrics inside PMM