Hi, I use SQL SERVER as database for grafa,
there is table in sql server as below
SELECT [ID]
,[Createdate]
,[MemoryCounter]
,[Thisvalue]
FROM [Dashboard].[dbo].[SQLMemory]
where memoryCounter=‘Available_physical_memory_MB’
in grafana query I put this but no data show and no error
SELECT
$__time(Createdate),
thisvalue as value,
MemoryCounter as metric
FROM
SQLMemory
WHERE
memoryCounter=‘Available_physical_memory_MB’ and
$__timeFilter(Createdate)
ORDER BY
Createdate ASC
please help
thanks
Lirus