Skip to Content
SAP SQL Anywhere

SQL Anywhere, on-demand edition Tenant Database Monitoring

Tags:

Module 7 - Tenant Database Monitoring

Once a SAP Sybase SQL Anywhere, on-demand edition Cloud is configured and is managing tenant databases, you will need a way to monitor and proactively detect problems in those tenant databases. The SQL Anywhere Monitor is a browser-based administration tool that provides you with information about the health and availability of your tenant databases.

Pre-requisites

You should now be familiar with creating a cloud, and adding hosts, servers and databases to that cloud. It is expected that you have created a cloud with a minimum of two cloud servers on multiple hosts and have loaded some databases into the cloud.

This module requires that you have the SQL Anywhere Monitor installed. A development version of the SQL Anywhere Monitor is installed as part of the SQL Anywhere Developer Edition, and is suitable for this module.

Database Monitoring

The SQL Anywhere Monitor is an existing application that can be used to monitor the health and availability of SQL Anywhere databases. You can use the SQL Anywhere monitor to track individual databases that are running in your cloud.

To monitor a database in your cloud:

  1. Install the SQL Anywhere Monitor on a computer that can make TCP/IP connections to hosts in your cloud.
  2. Open the monitor in your browser using the URL: http://localhost:4950. Note that the SQL Anywhere Monitor requires the Adobe Flash player to be installed on your machine. (Windows Server 2012 does not have Adobe Flash installed on IE9 by default. To install it, enable Desktop Experience in the Server Features list)
  3. Log in as an administrator. If you haven’t changed the defaults, the default user name is admin and the password is also admin.
  4. In the left navigation menu, choose Tools » Administration. Click Add to add a SQL Anywhere database as a resource to be monitored.
  5. Select SQL Anywhere Server as the type of resource to monitor, click Next. Then give the resource a name and click Next.
  6. Supply a connection string to the database you wish to monitor. Use the connection parameters that connect you to your tenant database. For a refresher on connecting in SQL Anywhere OnDemand Edition, see module 3 of the beta tutorial modules. Also remember that it is recommended that multiple hosts are specified in the case of failure with any of the hosts. In these parameters, the port number is optional if the default port number is being used. Recall that the server name must not be specified because of the use of automatic connection redirection, but the database name must be specified. You can use the Test Connection button to ensure that your connection parameters are correct.
  7. When you are finished, click Create to create the new resource in the monitor. Supply the DBA login and password and then close the Administration window.
  8. In the main window of the monitor, under Dashboards, click Add New. In the Add dashboard window, choose the resource you want to monitor. Change the name if you want and click OK when you finish.
  9. You should now see a new entry on the Dashboards list. Click the link for the dashboard you created to view the monitor data for your database.

You can explore the entire monitor data related to your database. Each of the widgets on the dashboard can also be customized to display only the data that is important to you.

You can also use the Administration menu to define and configure alerts and alert notifications. For details on the full capabilities of the SQL Anywhere Monitor, see:

http://dcx.sybase.com/index.html#1201/en/dbadmin/da-server-monitoring.html*d5e67692

No comments