Sep 28 2020 01:23 PM
It depends: which SQL (Azure SQL, SQL in a VM). In a VM, you can check eventlog by sending the eventlog to a workspace, and setting an alert on when SQL service stops. Azure SQL, I would check from the client VM, probably also eventlog to workspace, then monitoring for failed connection there.
Sep 28 2020 08:09 PM
Azure SQL Database already has built-in high availability.
SQL is deployed in IaaS VM ,and you can use features such as Failover Cluster, AlwaysOn, and more.