Tutorial: Monitoring resources with the Monitor

Use this tutorial to set up monitoring for a database, MobiLink server, or a Relay Server farm. This tutorial uses the Monitor Developer Edition.

Privileges

You must have the user ID and password for a user in the database being monitored who has the DROP CONNECTION system privilege.

You must be logged in to the Monitor as an administrator to perform the lessons in this tutorial. Read-only and operator users can only perform a subset of the tasks that an administrator can perform. To check your Monitor user type, log in to the Monitor, click Tools » User Settings, and review the User Type setting. See Monitor users.

To add a version 16 database, you must have the user ID and password for a user in the database who has the SYS_SAMONITOR_ADMIN_ROLE role. To add a pre-16.0 database, you must have the user ID and password for a user in the database that has DBA authority. These credentials are used to:

Connect to the database.
Create a new user named sa_monitor_user. The Monitor uses 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 the supplied user ID credentials from the Monitor. Because the sa_monitor_user is added to the database being monitored, it is not necessary to store the credentials of the user with the SYS_SAMONITOR_ADMIN_ROLE role or DBA authority anywhere outside the database that is being monitored.

Lesson 1: Logging in to the Monitor
Lesson 2: Adding a resource
Lesson 3: (Optional) Setting up alert emails
Lesson 4: Testing an alert
Lesson 5: Adding a new dashboard and widgets
Lesson 6: Closing database connections
Lesson 7: Stopping monitoring of resources
Lesson 8: (Optional) Monitoring a database mirroring system
Lesson 9: (Optional) Monitoring your read-only scale-out system from the SQL Anywhere Monitor

Discuss this page in DocCommentXchange.