# Reading MSSQL Server info about disk, cpu and memory utilization

**URL:** <https://discuss.elastic.co/t/reading-mssql-server-info-about-disk-cpu-and-memory-utilization/51307>\
**Category:** Logstash\
**Created:** [May 30, 2016, 10:47am UTC](https://discuss.elastic.co/t/reading-mssql-server-info-about-disk-cpu-and-memory-utilization/51307 "2016-05-30T10:47:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kennedy\_Kan1](https://avatars.discourse-cdn.com/v4/letter/k/cc9497/32.png) [@Kennedy\_Kan1](https://discuss.elastic.co/u/Kennedy_Kan1)\
**Post date:** [May 30, 2016, 10:47am UTC](https://discuss.elastic.co/t/reading-mssql-server-info-about-disk-cpu-and-memory-utilization/51307/1 "2016-05-30T10:47:39Z")

</div>

I know there is a jdbc input plugin and I do know the SQL in reading the data as stated in the topic but I have no idea how to use logstash to map them. Is there anyone who know how to resolve?

For example,  
I have created the file for reading CPU Utilization in SQL  
CPU utilization:

> SELECT  
> cpu\_total =  
> CASE WHEN cpu\_sql \> cpu\_total AND cpu\_sql \<= 99.  
> THEN cpu\_sql  
> ELSE cpu\_total  
> END,  
> cpu\_sql  
> FROM (  
> SELECT cpu\_total = 100 - x.value('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle/text())[1]', 'TINYINT')  
> FROM (  
> SELECT TOP(1) [timestamp], x = CONVERT(XML, record)  
> FROM sys.dm\_os\_ring\_buffers  
> WHERE ring\_buffer\_type = N'RING\_BUFFER\_SCHEDULER\_MONITOR'  
> AND record LIKE '%%'  
> ) t  
> ) x  
> CROSS JOIN (  
> SELECT  
> cpu\_sql = (  
> MAX(CASE WHEN counter\_name = 'CPU usage %' THEN t.cntr\_value \* 1. END) /  
> MAX(CASE WHEN counter\_name = 'CPU usage % base' THEN t.cntr\_value END)  
> ) \* 100  
> FROM (  
> SELECT TOP(2) cntr\_value, counter\_name  
> FROM sys.dm\_os\_performance\_counters  
> WHERE counter\_name IN ('CPU usage %', 'CPU usage % base')  
> AND instance\_name = 'default'  
> ) t  
> ) t

But how can I map the result into logstash

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [June 1, 2016, 5:32am UTC](https://discuss.elastic.co/t/reading-mssql-server-info-about-disk-cpu-and-memory-utilization/51307/2 "2016-06-01T05:32:08Z")

</div>

The jdbc input documentation contains a couple of examples of how it can be used. Could you be more specific about what you don't understand or where you're stuck?

---

<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:** [July 6, 2017, 4:55am UTC](https://discuss.elastic.co/t/reading-mssql-server-info-about-disk-cpu-and-memory-utilization/51307/3 "2017-07-06T04:55:04Z")

</div>

Closed on July 6, 2017, 4:55am UTC