Browse Prior Art Database

Real Time Database Performance Monitor, Application Workstation

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

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. The application sites should be able to report the results 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, Application Workstation

      When measuring database performance, a user-like scenario
should be used.  This scenario should use standard applications and
be controlled from a centralized site.  The application sites should
be able to report the results 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.

      Workstations can be configured as part of the database
environment and then measured automatically through the Real-Time
Database Performance Monitor System.  The workstations that are
measured contain database application code.  A workstation of this
nature will be referred to as an Application Workstation (AW).

      Each AW contains multiple programs.  Every AW contains a
Communication program.  This program coordinates requests coming
through the network from a Control Workstation and sends the request
to one or more database application programs. When requested, the
communication program will gather information from the database
application programs and send it back to the Control Workstation. The
communication program is automatically started on each AW and becomes
"attached" when the first request comes in from the Control
Workstation.  (We chose to use the automatic attach capability of IBM
OS/2* Extended Edition Communications Manager.)

      On each AW, we have defined two applications. The first is
transaction-oriented. The second is query-oriented.  This combination
gives...