SQL Availability

Brass Contributor

Is there anyway to get the SQL Availability ?

 

2 Replies

@loadedlouie27 

 

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.

@loadedlouie27 

 

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.