Lesson Learned #435:How to Know the Status of Your Azure SQL Database:Service Health-Resource Health

Posted by

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

Today, we had a service request our our customer wants to understand the health status of their Azure SQL Database. 

Know this is crucial for maintaining high availability. Microsoft Azure offers powerful monitoring features—Service Health and Resource Health—that can send you real-time alerts, helping you react quickly to any issues. This article will cover how to set up and use these features.


Azure Service Health

What is Service Health?

Service Health is a feature within the Azure portal that shows the status of Azure services across different regions. It includes information about outages, planned maintenance, and other events affecting Azure services, including Azure SQL Database.


How to Set it Up

  1. Open the Azure portal.
  2. Navigate to “Service Health” from the left-hand menu.
  3. Filter by “Azure SQL Database” to only display relevant events.



You can set up alerts to get notified when events occur that may affect your Azure SQL Database. These alerts can be sent via email, SMS, or other communication channels.


Azure SQL Database Resource Health


What is Resource Health?

While Service Health provides a broad view, Resource Health gives you a focused look at the state of individual resources like your specific SQL Database. It can quickly point you toward any immediate issues requiring attention.


How to Access Resource Health

  1. Open the Azure portal.
  2. Select the SQL Database you wish to monitor.
  3. Navigate to the “Resource Health” tab.


Example: Reacting to Azure Monitor Alerts


Consider the scenario where you receive an Azure Monitor alert email with the subject "Important notice: Azure Monitor alert MyNotificationsBBDD was activated."


Such an email could contain information similar to:

  • Time: September 25, 2023 15:42 UTC
  • Category: ResourceHealth
  • Level: Informational
  • Current Health Status: Available
  • Previous Health Status: Degraded


These notifications are crucial for immediate response and remediation. The alert email is part of Azure's integrated monitoring and alerting system and is triggered by Service Health and Resource Health metrics. In this case, the database went from a "Degraded" to an "Available" state, providing you with timely information to react appropriately.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.