No data show in grafic grafana sql server

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

wrong forum 2021-01-15T00:00:00Z

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.