Meticbeat can not collect all metric for MSSQL perfomance counter

[sondog]

Elasticsearch Version : 8.0.0
Kbana Version : 8.0.0
Metricbeat Version : 8.0.0
MSSQL version : Micvrosoft SQL Server 2017

MSSQL performance metricset | Metricbeat Reference [8.0] | Elastic

in documentaion,
metricbeat can collect 16 metric for performance counter

but,
i can get only 6 metric(even buffer.cache_hit, buffer.page_life_expectancy is null)

is there any solution?

or

could i get collecting logic MSSQL perfomance counter ? (i couldn't find source at github)

thanks

[Manoj_S_Shetty]

Hi @sondog ,

Can you please paste the output of the below SQL query for MSSQL server:

SELECT * FROM sys.dm_os_performance_counters WHERE counter_name = 'Page life expectancy' AND  object_name like '%Buffer Manager%'"

Thank you

[sondog]

Hello, @Manoj_S_Shetty

Thank you

[sondog]

Hi @Manoj_S_Shetty,

Could i know SQL query collects each metric?

ex)
mssql.performance.buffer.page_life_expectancy.sec (metricbeat field)
<->
SELECT cntr-value FROM sys.dm_os_performance_counters WHERE counter_name = 'Page life expectancy' (MSSQL SQL Query)

please let me know about collecting file path in github

thank you

[Manoj_S_Shetty]

@sondog Can we see your mssql config yaml file ?

Path: beats/performance.go at main · elastic/beats · GitHub