SQL Availability

%3CLINGO-SUB%20id%3D%22lingo-sub-1720869%22%20slang%3D%22en-US%22%3ESQL%20Availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1720869%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20anyway%20to%20get%20the%20SQL%20Availability%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1722111%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Availability%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1722111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714167%22%20target%3D%22_blank%22%3E%40loadedlouie27%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20depends%3A%20which%20SQL%20(Azure%20SQL%2C%20SQL%20in%20a%20VM).%26nbsp%3B%20In%20a%20VM%2C%20you%20can%20check%20eventlog%20by%20sending%20the%20eventlog%20to%20a%20workspace%2C%20and%20setting%20an%20alert%20on%20when%20SQL%20service%20stops.%20Azure%20SQL%2C%20I%20would%20check%20from%20the%20client%20VM%2C%20probably%20also%20eventlog%20to%20workspace%2C%20then%20monitoring%20for%20failed%20connection%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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.