Monitoring Data Base Performance

  • Jay-Louise Weldon
Part of the Applications of Modern Technology in Business book series (AMTB)


In selecting the logical structure and physical implementation for a data base the DBA must strike a delicate balance. For each application different structures and storage methods yield different cost-performance results. A configuration favorable to one application may be unfavorable, even untenable, to one or more of the others. The dba must weigh these trade-offs and select the configuration that produces the best overall performance for the least cost.


Data Base Data Channel Page Fault Average Queue Length Software Monitor 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    The “data administrator“ function, EDP Analyzer 10(H), November 1972.Google Scholar
  2. 2.
    Get more computer efficiency, EDP Analyzer 9(3), March 1971.Google Scholar
  3. 3.
    Cohen, Leo J., An overview of performance management for data base, Notes from a presentation to New York City Chapter of the ACM Special Interest Group on Management of Data, 1975.Google Scholar
  4. 4.
    Lyon, John K., The Database Administrator, John Wiley and Sons, New York, 1976.Google Scholar
  5. 5.
    B.c.s. Codasyl DDLC Data Base Administration Working Group, June 1975 Report. (Available from the British Computer Society, 29 Portland Place, London Q1N4HU.)Google Scholar
  6. 6.
    Ghosh, S. P., and W. G. Tuel, Jr., A design of an experiment to model data base system performance, IEEE Transactions on Software Engineering SE 2(2), pp. 97–106, June 1976.MATHCrossRefGoogle Scholar
  7. 7.
    Yao, S. B., An attribute-based model for database access cost analysis, ACM Transactions on Database Systems 2(1), pp. 45–67, March 1977.CrossRefGoogle Scholar
  8. 8.
    Borovits, I., and P. Ein-dor, Cost/utilization: A measure of system performance, Communications of the ACM 20(3), pp. 185–191 March 1977.CrossRefGoogle Scholar
  9. 9.
    Sherman, S. W., and R. S. Brice, Performance of a database manager in a virtual memory system, ACM Transactions on Database Systems 1(4), pp. 317–343, December 1976.CrossRefGoogle Scholar
  10. 10.
    Brice, R. S., and S. W. Sherman, An extension of the performance of a database manager in a virtual memory system using partially locked virtual buffers, ACM Transactions on Database Systems 2(2), pp. 196–207, June 1977.CrossRefGoogle Scholar
  11. 11.
    Lucas, Henry C, Jr., Performance evaluation and monitoring, ACM Computing Surveys 3(3), pp. 79–91, September 1971.MathSciNetMATHCrossRefGoogle Scholar
  12. 12.
    IBM, IMS DC Monitor, GB21-1336-0, IBM Corp., Productivity Application Development (1501 California Ave., Palo Alto, Ca. 94304), 1974.Google Scholar
  13. 13.
    IBM, Data Communications Analyzer (Dcanalyzer), G320-1532-0 (IBM Data Processing Division, 1133 Westchester Ave., White Plains, N.Y. 10604), December 1973.Google Scholar
  14. 14.
    Rustin, R., Data base management system performance estimation: An elementary approach, Proceedings of the Fifth Texas Conference on Computing Systems, pp. 115–126, University of Texas, Austin, Texas, October 1976.Google Scholar
  15. 15.
    Scheuerman, Peter, Concepts of a data base simulation language, Proceedings of the Association for Computing Machinery SIGMOD Conference, pp. 144–146, Association for Computing Machinery, New York, August 1977.Google Scholar

Copyright information

© Plenum Press, New York 1981

Authors and Affiliations

  • Jay-Louise Weldon
    • 1
  1. 1.Graduate School of Business AdministrationNew York UniversityNew YorkUSA

Personalised recommendations