This topic describes how to configure an alert rule for an ApsaraDB RDS for SQL Server instance. ApsaraDB RDS offers the monitoring and alerting feature. If exceptions are detected on your RDS instance or if your RDS instance is locked due to insufficient storage capacity, the system sends notifications to you.

Background information

The monitoring and alerting feature of ApsaraDB RDS is implemented by using Cloud Monitor. Cloud Monitor allows you to configure metrics and alert rules. You can also associate alert groups with metrics. If a metric meets the conditions that are specified in an alert rule, alerts are sent as emails to all the contacts in the alert group that is associated with the metric.

Turn on Initiative Alert

If you turn on Initiative Alert, an alerting mechanism is quickly created for your RDS instance. This allows you to obtain the exceptions of key metrics at the earliest opportunity. For more information, see Enable the initiative alert feature.

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Monitoring and Alerts.
  3. On the page that appears, click the Alerts tab. Then, turn on Initiative Alert.
    Initiative Alert

Create an alert rule

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Monitoring and Alerts.
  3. On the page that appears, click the Alerts tab.
  4. Click Set Alert Rule to go to the CloudMonitor console.
    Alert Rule Settings
  5. Create an alert group. For more information, see Create an alert contact or alert contact group.
  6. Create an alert rule. For more information, see Create an alert rule.
    Note You can also configure CloudMonitor to automatically monitor resources based on tags. For more information, see Monitor resources based on tags.

Manage an alert rule

  1. Access RDS Instances, select a region at the top, and then click the ID of the target RDS instance.
  2. In the left-side navigation pane, click Monitoring and Alerts.
  3. On the page that appears, click the Alerts tab.
  4. Click Set Alert Rule to go to the CloudMonitor console.
    Configure an alert rule
  5. On the Alert Rules page, find the alert rule that you want to manage and perform the following operations based on your business requirements:
    • Details: View details about the alert rule.
    • Alert History: View the alerts that were triggered by the alert rule within a specific time range.
    • Modify: Modify the alert rule. For more information, see Create an alert rule.
    • Disable: Disable the alert rule. After you disable the alert rule, no alerts are triggered even if the metric meets the conditions that are specified in the alert rule.
    • Delete: Delete the alert rule. After you delete the alert rule, the alert rule cannot be restored. You can only re-create the alert rule if necessary.

ApsaraDB RDS for SQL Server metrics

For more information, see RDS-SQLServer.