SQL Anywhere Monitor new features

Following is a list of additions to SQL Anywhere Monitor introduced in version 12.0.1.

  • The Monitor can now send email alerts through SMTP servers   The SQL Anywhere Monitor now supports sending email alerts through SMTP servers that require TLS connections (for example, GMail). See Enabling the Monitor to send alert emails.

  • Monitor databases in read-only scale-out and in database mirroring systems   The Monitor supports monitoring the database server of the root node in a read-only scale-out system and the primary database server in a mirroring system. In a mirroring system, the Monitor can be configured to always monitor the primary database server, even when a fail-over occurs. A new widget, the SQL Anywhere Scale-Out Topology widget, displays topology information for the SQL Anywhere mirroring and scale-out systems.

    To create a resource for a root node in a read-only scale-out system or the primary database in a mirroring system, use the Add Resources window and choose to create a SQL Anywhere Server resource. See Add resources.

    There is no difference in the resource configuration for a root node in a read-only scale-out system and other database servers. When the resource is configured or migrated, the Monitor detects that the resource is the root node in a read-only scale-out system.

    A resource for a primary database in a mirroring system requires special configuration. To ensure that the Monitor always monitors the primary database server even when a fail-over occurs, you must configure the resource using the following options:

    • In the Host field, specify the host names and port numbers of the computers running the primary and mirror servers in a comma-separated list. For example: my-primary-server:2638,my-mirror-server:49152.

    • Ensure that the Port field is empty.

    • In the Server field, type the alternate server name for the primary server. That is, specify the name that clients use to connect to the database server that is acting as the primary server in the database mirroring system.

    You must add the SQL Anywhere Scale-Out Topology to your dashboard as it is not one of the default widgets that appears when a new dashboards is created. See Widgets.

    See Lesson 7: (Optional) Setting up the Monitor to monitor a database that is part of a read-only scale-out system and Lesson 3: Monitoring a database mirroring system.

    Also, a new alert, Alert when the number of disconnected scale-out nodes exceeds the given threshold:, has been added. See Specifying alert thresholds.

  • New Monitor metrics and alert for MobiLink servers   The Monitor metrics for MobiLink server resources now includes a metric named Is Consolidated Available. This metric shows True if the MobiLink server can connect to the consolidated database. If the consolidated database becomes unavailable, then a Consolidated Database Unavailable alert is issued.

  • New names for MobiLink resource metrics   The following SQL Anywhere Monitor metrics for MobiLink server resources have changed:

    Old name New name
    Bytes Read Rate TCP Bytes Read Rate
    Bytes Written Rate TCP Bytes Written Rate

  • Alert Notification window   The Alert Notification window now includes two options that restrict the number of emails set per day and the type of email sent.

    • Only Send Email Notifications For High-Priority Alerts   Set this option to receive email notifications only when high-priority alerts are raised.

    • Do Not Send More Than The Given Number Of Email Notifications Per Day   Specify this option to limit the amount of notification emails sent to each user per day.

      See Enabling the Monitor to send alert emails.

  • Delete Alerts window   When the user selects an alert and clicks the Delete button, the Delete Alerts window appears, prompting the user to select one of the following options:

    • Delete Selected Alerts   Choose this option to only delete alerts selected in theAlert List widget.

    • Delete Alerts Received Before   Select this option to delete all alerts received before a specified time.

    • Delete Alerts For The Following Resource   Choose this option to delete all alerts for the selected resource.

      See Deleting alerts.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1