Lesson 2: Set up the Monitor to monitor a database

In this lesson, you start the SQL Anywhere sample database, demo.db, and then add this database as a resource to be monitored.

 To add a database resource to the Monitor

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

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

  3. Choose Tools » Administration. which is located on the left sidebar.

  4. Click Resources, and then click Add.

  5. Select SQL Anywhere Server, and then click Next.

  6. In the Name field, type demo12, and then click Next.

  7. In the Host field, type localhost, and in the Server field, type demo12.

  8. Click Create.

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

    When you add a database as a resource to be monitored, you must supply the DBA user ID and password for the database. 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 installed, see Installed objects.

    • Discard from the Monitor the DBA credentials. Because the 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 Installed objects.

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

  10. Click OK.

  11. Click Close.

  12. Choose Dashboards » Overview.

    The demo12 resource appears in the Resource List.

  13. Click demo12 to open the demo12 dashboard and view the collected metrics.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0