# Mssql.performance ignores some metrics (metricbeat) **URL:** \ **Category:** Beats\ **Tags:** metricbeat\ **Created:** [March 24, 2021, 11:27pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277 "2021-03-24T23:27:10Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Francisco\_Gomez1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/francisco_gomez1/32/78301_2.png) [@Francisco\_Gomez1](https://discuss.elastic.co/u/Francisco_Gomez1)\ **Post date:** [March 24, 2021, 11:27pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/1 "2021-03-24T23:27:10Z")
Hi. When im trying to use metricbeat to capture my SQL Server performance some metrics that should be included are completly ignored. this is my mssql.yml configuration: ![WhatsApp Image 2021-03-24 at 19.23.51](https://us1.discourse-cdn.com/elastic/original/3X/3/9/39202560f7d6afdb44b61d8ac7453c331a570dc8.jpeg) I should recieve all performance metrics but im just recieving these ones ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/f/4f1b7777f6bcb2f1e812590c4ef910b2cfedabd3.png) No transaction metrics or buffer cache ratio for example therefore i got empty dashboards in my kibana visualization. there isnt any error so i dont know what is exactly the problem. thanks for your time and hope you can help me. ---
**Author:** ![ChrsMark](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chrsmark/32/55858_2.png) [@ChrsMark](https://discuss.elastic.co/u/ChrsMark)\ **Post date:** [March 26, 2021, 9:15am UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/2 "2021-03-26T09:15:57Z")
Hi! What version of Metricbeat you are running? I'm looking into latest version's [docs](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-mysql.html) and I don't see `transaction_log` metricset 🤔 . C. ---
**Author:** ![Francisco\_Gomez1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/francisco_gomez1/32/78301_2.png) [@Francisco\_Gomez1](https://discuss.elastic.co/u/Francisco_Gomez1)\ **Post date:** [March 26, 2021, 2:14pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/3 "2021-03-26T14:14:16Z")
Hi , im using metricbeat 7.12 (latest) Is MSSQL (SQL Server) not MySQL In the docs if you go to the MSSQL module for the implementation you can see the next example ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/2/b2ed5bef3feee3f6e9a7319e49fe93f43c29366b.png) ere is the dock for the mssql implementation in metricbeat 7.12 : [MSSQL module | Metricbeat Reference [7.12] | Elastic](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-mssql.html) ---
**Author:** ![ChrsMark](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chrsmark/32/55858_2.png) [@ChrsMark](https://discuss.elastic.co/u/ChrsMark)\ **Post date:** [March 26, 2021, 2:49pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/4 "2021-03-26T14:49:43Z")
Gocha @Francisco_Gomez1 , thanks for making it clear! Do you think it could be a [compatibility](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-module-mssql.html#_compatibility_32) issue? What is the version of the targeted SQL server? @Mario_Castro does this ring any bells to you? ---
**Author:** ![Francisco\_Gomez1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/francisco_gomez1/32/78301_2.png) [@Francisco\_Gomez1](https://discuss.elastic.co/u/Francisco_Gomez1)\ **Post date:** [March 26, 2021, 4:25pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/5 "2021-03-26T16:25:42Z")
Is 2012, MSSQL only works for 2017 and beyond? ---
**Author:** ![Mario\_Castro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mario_castro/32/35107_2.png) [@Mario\_Castro](https://discuss.elastic.co/u/Mario_Castro)\ **Post date:** [March 29, 2021, 2:55pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/6 "2021-03-29T14:55:18Z")
Well, the module is only tested and develop with v2017 in mind, which means that some things may work in older versions but not all of them. Most of metrics in `performance` metricset comes from `sys.dm_os_performance_counters` and maybe they had a different name in 2012 than 2017. For example the buffer cache hit ratio is a query something like `SELECT * FROM sys.dm_os_performance_counters WHERE counter_name = 'Buffer cache hit ratio' AND object_name = 'SQLServer:Buffer Manager'` so if the `counter_name` or the `object_name` is different in v2012, that metric will be omitted. Could that be the case? Could you check in your DB? If that's the case, it's by design but it doesn't mean that you cannot open an Enhancement Request on Beats repo so that maybe someone can include support for v2012. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 26, 2021, 4:56pm UTC](https://discuss.elastic.co/t/mssql-performance-ignores-some-metrics-metricbeat/268277/7 "2021-04-26T16:56:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.