# MS SQL perfomance logs to logstash

**URL:** <https://discuss.elastic.co/t/ms-sql-perfomance-logs-to-logstash/125892>\
**Category:** Logstash\
**Created:** [March 28, 2018, 9:06am UTC](https://discuss.elastic.co/t/ms-sql-perfomance-logs-to-logstash/125892 "2018-03-28T09:06:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MrFrost](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@MrFrost](https://discuss.elastic.co/u/MrFrost)\
**Post date:** [March 28, 2018, 9:06am UTC](https://discuss.elastic.co/t/ms-sql-perfomance-logs-to-logstash/125892/1 "2018-03-28T09:06:16Z")

</div>

Hello,

I am trying to monitor MS SQL performance by pushing below data to logstash and then to dashboards in Kibana:  
Average Select in time  
Average Update in time  
Average Delete in time  
Average Select in time  
Average Select in time  
Memory usage  
CPU usage  
Running threads  
etc.

The issue is whatever i try does not work.

MetricBeats does not support MSSQL, at least I did not find any documentation or examples how to do it. (yes there is feature request already but seems like it is ignored for 2 years already and it does not look to be ready anytime soon)

JDBC looks like it is good for getting specific data from DB but not performance metrics almost in real time like Beats do it.

Any suggestions how to grab performance metric data for MS SQL?

--Update--  
I did try to use MetricBeat and send perfmon results to logstash like below but all I get after parsing is garbage without any results:

```
- module: windows
  metricsets: ["perfmon"]
  period: 10s
  perfmon.counters:
  - instance_label: "mssql.pool"
  measurement_label: "mssql.pool.cpu.usage"
  query: '\MSSQL$MyDatabase:Resource Pool Stats(internal)\CPU usage %'
  format: "long"
```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 25, 2018, 9:06am UTC](https://discuss.elastic.co/t/ms-sql-perfomance-logs-to-logstash/125892/2 "2018-04-25T09:06:17Z")

</div>

Closed on April 25, 2018, 9:06am UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.