Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database monitoring


SQL Anywhere Monitor

The SQL Anywhere Monitor, also referred to as the Monitor, is a browser-based administration tool that provides you with information about the health and availability of SQL Anywhere databases (including databases in read-only scale-out and mirroring systems), MobiLink servers, MobiLink server farms, and Relay Server farms.

This section describes how to use the Monitor to collect metrics about SQL Anywhere databases, MobiLink servers, and Relay Server farms.

The Monitor provides the following functionality:

  • Constant data collection   Unlike many of the other administration tools available with SQL Anywhere, the Monitor collects metrics all the time, even when you are not logged in to the browser. The Monitor collects metrics until you shut it down.

  • Email alert notification   As the metrics are collected, the Monitor examines the metrics and can send email alerts when it detects conditions that indicate something is wrong with a resource.

  • Browser-based interface   At any time, you can log in to the Monitor using a browser to review alerts and metrics that have been collected.

  • Monitor multiple databases, MobiLink servers, MobiLink server farms, and Relay Server farms   From one tool, you can simultaneously monitor multiple resources running on the same or different computers.

  • Minimal performance impact   The Monitor can be used routinely in development and production environments because monitoring does not degrade performance.

The Monitor is designed to help any type of user, whether they are a DBA or not, who is responsible for such tasks as:

  • Ensuring that a database, a MobiLink server, or a Relay Server farm is connected to the network.

  • Ensuring that there is enough disk space or memory available for a database, a MobiLink server, or a Relay Server farm.

  • Ensuring that users aren't blocked or that queries aren't taking too long to run.

  • Reviewing the number of synchronizations a MobiLink server performs over a specified time.

  • Ensuring that a Relay Server is ready to relay traffic.

  • Reviewing the traffic volume, throughput, and failure rate of a Relay Server farm.

 See also

Monitor architecture
Quick start to using the Monitor
Tutorial: Monitoring resources with the Monitor
Start the Monitor
Stopping the Monitor
Logging in remotely to the Monitor
Logging out from the Monitor
Overview dashboard
Administration window
Monitor users
Backing up the Monitor
List of database objects installed by the Monitor
SQL Anywhere Monitor in a production environment
Upgrading the Monitor and migrating resources and metrics
Monitor communications security
Troubleshooting the Monitor