Add resources

To monitor a database (including databases in read-only scale-out or mirroring systems), a MobiLink server or a MobiLink server farm or a Relay Server farm, an administrator must first add the resource to the Monitor. By default, after the resource is added, monitoring starts.

As an administrator, you can add a resource one at a time or you can add multiple resources via an CSV file. See Adding multiple resources.

 Add a database, a MobiLink server or a Relay Server farm resource to monitor

  1. Log in to the Monitor as an administrator.

  2. Click Administration.

  3. Click Resources.

  4. Click Add.

  5. In the Add Resource window:

    1. Click the type of resource that you want to monitor. To monitor databases in read-only scale-out or mirroring systems choose to add a SQL Anywhere Database resource.

    2. Click Next.

    3. In the Name field, type a name for the resource. This is the name that will appear in the Monitor, and then click Next.

    4. In the Host field, specify the hostname or IP address of the computer on which the database server, the MobiLink server or the Relay Server farm is running. You can use the name localhost to represent the current computer. This value is required. See Host connection parameter.

      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.

      • In the Port field, ensure that it 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.

    5. Click Next.

    6. Follow the instructions in the Add Resource window to add a resource to monitor a database, a MobiLink server or a Relay Server farm.

      For MobiLink, when you add the resource you must supply a MobiLink user ID and password to connect to the MobiLink server. These credentials are used to connect to the MobiLink server. The MobiLink user ID and password are stored in the Monitor.

    7. Click Create.

      The resource is added and monitoring of the resource starts.

  6. For a database, when prompted, enter the DBA user ID and password for the database, and then click Close.

    These credentials are used to:

    • Connect to the database.

    • Create a new user named sa_monitor_user. The Monitor uses the sa_monitor_user to connect to the database and monitor it.

    • Install the database objects needed by the sa_monitor_user to monitor the database. For a list of the objects that are installed, see List of database objects installed by the Monitor.

    • Discard from the Monitor the DBA credentials. Because sa_monitor_user is added to the database being monitored, it is not necessary to store the DBA credentials anywhere outside the database that is being monitored. See List of database objects installed by the Monitor.

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

  7. Click Close.

  8. Click Close.

    The resource appears in the Overview dashboard Resource List.

  9. (Optional) Add a dashboard for the resource. By default when a resource is added, a dashboard is not.

    1. Open the Overview dashboard.

      Click Dashboards » Overview.

    2. In the Resource List, click the new resource.

      The Monitor creates and opens a new dashboard for the resource. The name of the new dashboard appears in the Dashboards section of the sidebar. See Dashboards.

  10. (Optional) Add a widget to your dashboard. See Widgets.

    To view the topology of SQL Anywhere read-only scale-out and mirroring systems, you must add a SQL Anywhere Scale-Out Topology widget. See SQL Anywhere Scale-Out Topology widget.

 Add a MobiLink server farm resource to the Monitor

  1. Log in to the Monitor as an administrator.

  2. Click Administration.

  3. Click Resources.

  4. Click Add.

  5. Follow the instructions in the Add Resource window to add a resource to monitor a MobiLink server farm.

    The Monitor collects metrics about the MobiLink server farm as well as each server that is part of the farm. When you add a MobiLink server farm as a resource, you must specify the servers that are part of the farm and if required add the servers as resources.

  6. Click Create.

    The resource is added and monitoring of the resource starts.

  7. Click Close.

  8. Click Close.

    The resource appears in the Overview dashboard Resource List.

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