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 » Resources

 

Adding a database resource

Add a database (including databases in read-only scale-out and mirroring systems) as a resource to the Monitor.

Prerequisites

You must be a Monitor administrator.

To add a version 16 database, you must have the user ID and password for a user in the database that has the SYS_SAMONITOR_ADMIN_ROLE role. To add an earlier database, you must have the user ID and password for a user in the database that has DBA authority.

Context and remarks

You can add a resource one at a time or you can add multiple resources via a CSV file.

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, the Monitor detects that the resource is the root node in a read-only scale-out system.

 Task
  1. Log in to the Monitor.

  2. Click Administration.

  3. Click Resources.

  4. Click Add.

  5. In the Add Resource window:

    1. Click SQL Anywhere Server

    2. Click Next.

    3. In the Name field, type a name for the resource. This is the name that appears 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 is running. You can use the name localhost to represent the current computer. This value is required.

      If monitoring the primary database in a mirroring system, 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.

    5. (Optional) In the Port field, specify the TCP/IP port that the database is running on.

      If monitoring the primary database in a mirroring system, ensure that the Port field is empty.

    6. (Optional) In the Databases field, specify the database name.

    7. (Optional) In the Server field, specify the server name.

      If monitoring the primary database in a mirroring system, n 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.

    8. (Optional) In the Other field specify a semicolon delimited string of connection parameters.

    9. Click Next.

    10. Follow the remaining instructions.

    11. Click Create.

  6. When prompted, enter the user ID and password of a user that has the SYS_SAMONITOR_ADMIN_ROLE role or DBA authority, 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.

    • Discard from the Monitor the user credentials. Because the sa_monitor_user is added to the database being monitored, it is not necessary to store the user credentials outside the database that is being monitored.

  7. Click Close.

  8. Click Close.

Results

The resource is added and monitoring of the resource starts automatically. The resource appears in the Overview dashboard Resource List.

Next

Optionally, you can add a dashboard for the resource. By default, when a resource is added a dashboard is not.

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

 See also