Grafana Dashboard not loading Instances

General
1

Hello Team,

I deployed SQLWatch successfully, and the central repository is pulling data as required,

but the Grafana dashboard only shows the central repository, how do we get it to show all the instances?

(I have 300 servers to monitor, so I can’t connect directly to them all, Central Repository is the best)

Also, Grafana works because there is no PowerBI service with this customer, and they need to have the dashboard on the screens.

2

did you try running the query from Grafana on the central repo database to see what it returns? To see if the problem is with Grafana or the data?

3

nopes,

please how do I do that?

4

single instance
single instance1806×1085 220 KB

5

the bottom table looks to be the [dbo].[sqlwatch_config_sql_instance] can you execute the query from Grafana (edit dashboard and preview the query), alternatively, can you see what’s in the [dbo].[sqlwatch_meta_server] table?

6

Thanks Marcin

The table is populated

Here you go

query output
query output1263×506 86.9 KB

7

Thanks. When you go to Grafana, click on Edit Panel and then Query Inspector to see the query Grafafna generated. Can you run this query in SQL and see what it returns?

8

Hello Marcin,

Please find attached the query from the dashboard. its the same as the above.

grafana-output-meta table
grafana-output-meta table1767×547 102 KB

In other news, I did another deployment and the meta table has only the default monitoring instance (while the imports are successful from the linked servers).
Any ideas

9

Any response to this, please?

10

Hi, were you able to get the query out of grafana panel (say CPU or any other metric) and run in SQL?