Introducing the SQL Anywhere Monitor

The SQL Anywhere Monitor, also referred to as the Monitor, is a web browser-based administration tool that provides you with information about the health and availability of SQL Anywhere databases and MobiLink servers.

This chapter describes how to use the Monitor to collect metrics about SQL Anywhere databases. For information about using the Monitor with MobiLink servers, see SQL Anywhere Monitor for MobiLink.

The Monitor provides the following functionality:

Constant data collection Unlike many of the other administration tools available with SQL Anywhere 11, the Monitor collects metrics all the time, even when you are not logged in to the web 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 database.
Browser-based interface At any time, you can connect to the Monitor using a web browser to review alerts and metrics that have been collected.
Monitor multiple databases and MobiLink servers From one tool, you can simultaneously monitor SQL Anywhere databases and MobiLink servers running on the same or different computers.
For information about monitoring MobiLink servers, see SQL Anywhere Monitor for MobiLink.
Minimal performance impact The Monitor can be used routinely in development and production environments because monitoring does not degrade performance.

Requirements

It is recommended that install the latest version of Adobe Flash Player that is available for your operating system. The Monitor is backwards compatible with version 9 of Adobe Flash Player. To determine the correct version, visit http://www.adobe.com/products/flashplayer/systemreqs/.
You must enable JavaScript in your web browser.
You must have SQL Anywhere 11.0.1 installed.

Running the Monitor in a production environment

You can install and run the Monitor on a separate computer. This prevents the Monitor resources and configuration from being overwritten during subsequent SQL Anywhere upgrades or updates. Installing on a separate computer is recommended if you want to use the Monitor in a production environment. See Installing the SQL Anywhere Monitor on a separate computer.

Limitations

You can use the Monitor to collect metrics about the following types of SQL Anywhere databases and MobiLink servers:
- SQL Anywhere 9.0.2, 10.0.0, 10.0.1, 11.0.0, and 11.0.1
- MobiLink 11.0.0 with at least the first EBF applied and 11.0.1
You can only run one Monitor on a computer.
You cannot use the Monitor to optimize queries or determine the speed of your application. If you are interested in tuning database and application performance, you can use such tools as the Application Profiling Wizard, the Sybase Central Performance Monitor, or the Windows Performance Monitor.