Browse Prior Art Database

Real-time Database Performance Monitor System

IP.com Disclosure Number: IPCOM000121235D
Original Publication Date: 1991-Aug-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 2 page(s) / 83K

Publishing Venue

IBM

Related People

Collins, TW: AUTHOR [+2]

Abstract

When measuring database performance, a user-like scenario should be used. This scenario should use standard applications and be controlled from a centralized site. Also, the centralized site should show the statistical results from the scenario. The sites which are running the application should be able to report the information to the central site. Obtaining accurate measurements of this performance is critical to knowing how to set the database environment topology. Getting the information as fast as possible allows for many projections to be done with little overhead.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Real-time Database Performance Monitor System

      When measuring database performance, a user-like scenario
should be used.  This scenario should use standard applications and
be controlled from a centralized site. Also, the centralized site
should show the statistical results from the scenario.  The sites
which are running the application should be able to report the
information to the central site.  Obtaining accurate measurements of
this performance is critical to knowing how to set the database
environment topology.  Getting the information as fast as possible
allows for many projections to be done with little overhead.

      In the past, certain hardware must be set up to monitor
performance. Statistics were accumulated by applications and analyzed
later.

      Disclosed here is a system by which performance of the OS/2*
Extended Edition Database Manager Rel 1.2 (and later) can be measured
dynamically. The system contains one workstation for monitoring and
at least one other workstation that will run a database application.
On the control workstation, a Presentation Manager* (PM) program
accepts user input and passes instructions to the workstations that
are running the database application.
The Control Workstation

      The control workstation starts a Presentaton Manager program
that displays a graphical user interface.  This program also starts a
communications program.  This communications program is used to
communicate between the Control Workstation and the Application
Workstations running database applications.  Whenever the user
requests a measurement, messages are sent from the Control
Workstation to the Application Workstation(s).  Each Application
Workstation then replies to the message and may return performance
information to the Control Workstation.
The Application Workstation

      Each Application Workstation starts a compl...