Lesson 2: Set up the Monitor to monitor a database

The Monitor collects metrics from databases and MobiLink servers. In this section, you start the SQL Anywhere sample database, demo.db, and then add the database as a resource to be monitored. To collect metrics from a MobiLink server, see Lesson 2: Set up the Monitor to monitor a MobiLink server.

To add a resource to monitor
  1. Start the SQL Anywhere sample database. From the Start menu, choose Programs » SQL Anywhere 11 » SQL Anywhere » Network Server Sample.

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

    1. Click Login.

    2. In the User Name field, type admin, and in the Password field, type admin.

    3. Click Login.

  3. Click the Administration tab.

  4. Click the Resources tab.

  5. Click Add.

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

  7. Name the resource demo11, and then click Next.

  8. In the Host field, type localhost, and in the Server field, type demo11.

  9. Click Create.

  10. 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.

    The Monitor installs the monitoring objects in the demo11 database. The new resource, demo11, is created and monitoring starts.

  11. Click OK.

  12. Click the Monitoring tab.

    The demo11 resource appears on the Monitoring tab, and the collected metrics appear on the tabs in the bottom pane.