I want to display a panel with Buffer cache hit ratio.
I know the query for that
SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 as BufferCacheHitRatio
FROM sys.dm_os_performance_counters a
JOIN (SELECT cntr_value,OBJECT_NAME
WHERE counter_name = 'Buffer cache hit ratio base’
AND OBJECT_NAME = ‘SQLServer:Buffer Manager’) b ON a.OBJECT_NAME = b.OBJECT_NAME
WHERE a.counter_name = 'Buffer cache hit ratio’
AND a.OBJECT_NAME = ‘SQLServer:Buffer Manager’
But how can i pull this off in grafana.
When i try to query it shows a lot of measurements with different names from sql tables.
I am new to grafana ,so excuse me if it sounds stupid.?
Additional info…I am using a telegrf agent and using sql server plugin.