Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Monitoring your database » SQL Anywhere Monitor » Tutorial: Using the Monitor

 

Lesson 3: Test an alert

In this lesson, you intentionally trigger an alert so you can practice handling alerts.

 ♦  To view and resolve an alert
  1. Trigger an alert by shutting down the resource.

    For example:

    1. On Windows, double-click the network server icon in the system tray for the demo12 database server.

    2. Click Shut Down in the database server messages window.

    3. Click Yes.

  2. Log in to the Monitor as an administrator. See Lesson 1: Log in to the Monitor as the default administrator.

  3. Choose Dashboards » Overview.

    In the Resource List, the Status for the demo12 resource changes to a red circle with a white x through it. This icon indicates that the resource is unavailable.

    The Resource List with the demo12 resource unavailable.

    In the Alerts widget, an Availability Alert appears and its status is Active.

    Alerts List with an Active alert.

    It can take a few seconds for these changes in state and status to occur. By default, the Monitor collects information from the resource every 30 seconds. See Collection intervals.

  4. In the Alerts dashboard, click the Availability Alert, and then click Details to read the description.

  5. Click OK to close the alert.

  6. Restart the sample database.

    Start the SQL Anywhere sample database. From the Start menu, choose Programs » SQL Anywhere 12 » SQL Anywhere » Network Server Sample.

    In the Monitor, in the Resource List, the Status for the demo12 resource changes to a yellow triangle. This icon indicates that the resource is being monitored and it has an alert. In the Alerts List, the State of the Availability Alert changes to Inactive. An inactive alert indicates that the issue that triggered the alert is no longer present, but the alert has not been resolved or deleted.

    Alerts List with an Resolved by admin alert.
  7. Resolve the alert by selecting the alert and clicking Mark Resolved.

    Note

    Only administrators and operators can resolve and delete alerts. See Monitor users.

    Now in the Resource List, the Status for the demo12 resource is blank. No icon in the Status column indicates that the resource is being monitored and it has no alerts. In the Alerts List, the State of the Availability Alert changes to Resolved by admin where admin is your Monitor user name.

    Alerts list with a Resolved alert.
  8. Delete the alert by selecting the alert and clicking Delete.

    When prompted, click Yes to confirm the deletion.