Uptime Monitoring of Azure Databases in Azure Dashboards

Question

Hi folks, I came across this interesting question by Pradeep Kandel that is

https://techcommunity.microsoft.com/t5/azure-data/uptime-monitoring-of-azure-databases-in-azure-dashboards/m-p/3677197

" I was looking for if there can be a way to monitor Azure Databases (SQL/ MySQL) uptime and present that into a shared dashboard so that uptime of all databases in Azure subscription can be monitoring from single pane of glass.

Is this even possible?

Would really appreciate your thoughts and support on this"

Meanwhile I have been through below documentation

https://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor?view=azuresql

Any suggestion by experts?

Answer 1

You can use Grafana instance to monitor Azure SQL and Azure SQL for MySQL. You can create your own dashboards with Grafana. To specifically monitor uptime of Azure resources you can combine Grafana with Prometheus as explained here.

You can also combine Grafana with Telegraf to get deep insight with performance counters also, like no other monitor service can offer at this time.

Making all these configurations can be complex though

Answer 2

Check the below links, please.

https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-health-to-troubleshoot-connectivity?view=azuresql

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-insights-alerts?view=azuresql