Apr 10 2019
07:31 AM
- last edited on
Apr 07 2022
05:44 PM
by
TechCommunityAP
Apr 10 2019
07:31 AM
- last edited on
Apr 07 2022
05:44 PM
by
TechCommunityAP
I need a log analytics query that will tell me whether a particular SQL database is available or not. In some instances, database was down. We would like to create an alert using a query in case database is not available. Can anyone help with this?
Apr 10 2019 02:47 PM
I used Azure functions to query a SQL database and then send the result to Azure Log Analytics
This is the website I used as a reference
https://docs.microsoft.com/en-nz/azure/azure-monitor/platform/data-collector-api#sample-requests