Home

	Expand Search

Adaptive Server Enterprise Monitor Client-Library Programmer's Guide

Chapter 1: Getting Started with Monitor Client Library

What is Adaptive Server Enterprise MonitorTM

What is Adaptive Server Enterprise Monitor^TM

Adaptive Server Enterprise Monitor provides a way to monitor Adaptive Server performance in real time or in a historical data-gathering mode. System administrators can use this information to identify potential resource bottlenecks, to research current problems, and to tune for better performance. Adaptive Server Enterprise Monitor provides feedback for tuning at several levels:

• Adaptive Server configuration
• Table and index design
• SQL statements in applications and stored procedures

Adaptive Server Enterprise Monitor Components

Adaptive Server Enterprise Monitor consists of four components that gather or display Adaptive Server performance data:

• Monitor Server - A server that collects Adaptive Server performance data in real time and makes the data available to the other Adaptive Server Enterprise Monitor components. Monitor Server is a Sybase Open Server^TM application.
• Historical Server - A server that obtains Adaptive Server Enterprise performance data from Monitor Server and saves the data in files for deferred analysis. Historical Server is a Sybase Open Server application.
• Monitors in the Adaptive Server Enterprise Plug-in for Sybase Central (Monitor Viewer) - The monitors provide a graphical user interface (GUI) to Monitor Server. They obtain Adaptive Server performance data from Monitor Server and display the data in real time in tables and graphs.
• Monitor Client Library - An application programming interface (API) to Monitor Server available to users for developing monitoring applications. Monitor Viewer and Historical Server are Monitor Client Library applications.

Adaptive Server Enterprise Monitor Architecture

The following figure shows the relationships between Adaptive Server and the various components of Adaptive Server Enterprise Monitor.

Figure 1-1: Adaptive Server Enterprise Monitor architecture

Adaptive Server saves performance data in a shared memory area that Monitor Server reads. Because of this shared memory technique, Monitor Server must be installed and running on the same machine as the Adaptive Server installation being monitored. A one-to-one relationship exists between Adaptive Server and Monitor Server. For more information about Monitor Server, see Sybase Adaptive Server Enterprise Monitor Server User's Guide.

Monitor Client Library applications obtain Adaptive Server performance statistics from Monitor Server. These applications are clients of Monitor Server. For performance reasons, Sybase recommends running Monitor Client Library applications on machines other than the ones where Adaptive Server/Monitor Server pairs are running.

Monitor Viewer in Sybase Central includes a set of monitors showing different aspects of Adaptive Server resource usage at various levels of detail. Each open monitor is a separate application, with a unique client connection to Monitor Server. In Sybase Central, each Adaptive Server installation has its own Monitors folder containing the set of monitor objects. See Managing and Monitoring Sybase Adaptive Server Enterprise for more information about the monitors.

Historical Server collects performance information from Monitor Server and saves the information in files for deferred analysis. Historical Server interfaces let users specify the data to collect and the time period desired. They also include a historical data playback feature. The interfaces are:

• A command interface in isql. For more information, see Sybase Adaptive Server Enterprise Monitor Historical Server User's Guide.
• A programming interface using Monitor Client Library. For more information, see Chapter 3, "Monitor Client Library Functions,"and Sybase Adaptive Server Enterprise Monitor Historical Server User's Guide.