Azure SQL Database Database Off-line Alert


Use the Database Off-line alert in Mini DBA to monitor Azure SQL Database instances and make this condition visible before it becomes a wider database incident.

Screenshot pending: Mini DBA Azure SQL Database Database Off-line alert screenshot placeholder

Alert Summary

  • Platform: Azure SQL Database
  • Alert category: Availability
  • Default enabled: true
  • Default evaluation frequency: Minute

What Mini DBA Checks

Mini DBA describes this alert as: Any databases are not in an online state The default evaluation frequency is Minute, so the alert is intended to be close enough to operational reality for live triage.

Why This Alert Is Helpful

This alert protects availability by warning when Mini DBA cannot reach the monitored Azure SQL Database instance or when the service state changes unexpectedly. It is often the first signal that users will see connection failures before deeper diagnostic metrics can be collected.

When To Enable It

Enable it on every production and customer-facing Azure SQL Database instance. For development systems, keep it enabled only when the instance is expected to be continuously available or when it supports automated testing and demos.

Threshold Guidance

This alert is not primarily driven by a numeric threshold in Mini DBA. Tune the schedule, scope, severity, and notification route so that the alert matches the importance of the instance. Use higher thresholds on batch-heavy, development, or intentionally bursty systems where brief pressure is expected. Use lower thresholds on latency-sensitive production systems, small instances with little headroom, and services with strict recovery or availability commitments.

Remediation For An Active Alert

Confirm the host, listener, service, firewall, DNS, and credentials first. Check whether planned maintenance is in progress, then use the relevant Azure SQL Database activity and service logs to decide whether the problem is network, engine startup, authentication, or resource exhaustion.

Investigation Workflow

  1. Confirm the alert is still active and note the first seen time, affected instance, and severity.
  2. Review the current metric, the recent trend, and the affected database, login, host, or application in Mini DBA before changing configuration or ending sessions.
  3. Compare the current value with the normal baseline for the same time of day or maintenance window.
  4. Record the cause, corrective action, and whether thresholds or routing should be adjusted after the incident.

Avoiding Alert Noise

If the alert creates repeated noise, review whether it is enabled on the correct instances, whether maintenance windows are configured, and whether the minor and major routes match the real business impact. Keep enough history to prove the new setting before changing it broadly.

Related Pages