Browse Prior Art Database

Real-time Database Performance Monitor Control Workstation

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

Publishing Venue

IBM

Related People

Chang, PY: AUTHOR [+4]

Abstract

When measuring database performance, a user-like scenario should be used. This scenario should be able to be controlled from a centralized monitor where statistical read-outs regarding the performance of the system can be shown in real time.

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 Control Workstation

      When measuring database performance, a user-like scenario
should be used.  This scenario should be able to be controlled from a
centralized monitor where statistical read-outs regarding the
performance of the system can be shown in real time.

      We have designed such a monitor and have used it in showing the
OS/2* Parallel Database at the 1990 Fall COMDEX convention. This
monitor, referred to as the Control Workstation (CW), is part of a
system called the Real-Time Database Performance Monitor.

      There are two programs executing on the CW. One of these is
used to display information and collect user input. The other is used
to disseminate information to the Application Workstations within the
system.

      A Presentation Manager program provides the user with an
interactive display. This program also starts the communication
program which will route the user requests through the system.  The
user interface program displays transactions per second with a
speedometer and query response time with a clock.  These measurements
are also graphed. When invoking the Presentation Manager* program on
the CW, a user may supply parameters.  These parameters specify the
maximum number of transactions per second for the speedometer, the
number of Application Workstations to communicate to, the number of
transaction applications to run at each Application Workstation, the
think time to be used when running the transaction application, and a
communications socket number when using TCP/IP communication
protocol.

      The CW records the performance statistics and the time between
collections. In this manner, the CW can keep track of pe...