Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database monitoring » SQL Anywhere Monitor » Tutorial: Monitoring resources with the Monitor

 

Lesson 9: (Optional) Monitoring your read-only scale-out system from the SQL Anywhere Monitor

Start a SQL Anywhere database that is the root node in a read-only scale-out system and then add this database as a resource to be monitored from SQL Anywhere Monitor.

Prerequisites

This tutorial assumes that you have a running read-only scale-out system as described in Tutorial: Creating a read-only scale-out system.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Monitoring resources with the Monitor.

 Task

  1. Start the SQL Anywhere Monitor. Click Start » Programs » SQL Anywhere 16 » Administration Tools » SQL Anywhere Monitor.

  2. Log in to the Monitor as the default administrator user:

    1. In the User Name field, type admin.

    2. In the Password field, type admin.

  3. Add scaleoutdemo.db as a resource to the Monitor:

    1. In the Tools sidebar, click Administration.

    2. Click Resources, and then click Add.

    3. Click SQL Anywhere Server, and then click Next.

    4. In the Name field, type scaleoutdemo, and then click Next.

    5. In the Host field, type localhost.

    6. In the Server field, type scaleout_root_demo.

    7. Click Create.

    8. When you are prompted for the required authorization, type DBA in the User ID field and sql in the Password field. Click OK.

      The resource is added and monitoring of the resource starts automatically.

    9. Click Close twice.

  4. Add a widget to monitor scaleoutdemo.db:

    1. In the Dashboard sidebar click scaleoutdemo.

    2. In the top right corner of the scaleoutdemo dashboard, click Customize » Add Widget.

    3. Select SQL Anywhere Scale-Out Topology and click Next.

    4. In the What do you want to name this widget field, type scaleoutwidget.

    5. In the Which resource are you interested in field, click scaleoutdemo.

    6. Click Create.

    The new widget appears in the dashboard:

    SQL Anywhere Scale-Out Topology widget for read-only scale-out system.

    The topology widget displays the following columns and their possible values:

    • Server Name   The name of the node in the scale-out system.

    • Type   The database server's role. The type is either Partner - Primary or Copy, depending on how the server was defined when the read-only scale-out system was created.

    • State   The connection status of the node. Can be either Connected or Disconnected.

    • Connections   The current number of connections to this node.

    • Last Updated   The last time the database server updated its status.

Results

You have added your read-only scale-out system as a resource to the SQL Anywhere Monitor, created a widget to monitor your read-only scale-out system, and collect metrics.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0