Monitoring Data Base Performance
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.
KeywordsData Base Data Channel Page Fault Average Queue Length Software Monitor
Unable to display preview. Download preview PDF.
- 1.The “data administrator“ function, EDP Analyzer 10(H), November 1972.Google Scholar
- 2.Get more computer efficiency, EDP Analyzer 9(3), March 1971.Google Scholar
- 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.Lyon, John K., The Database Administrator, John Wiley and Sons, New York, 1976.Google Scholar
- 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
- 12.IBM, IMS DC Monitor, GB21-1336-0, IBM Corp., Productivity Application Development (1501 California Ave., Palo Alto, Ca. 94304), 1974.Google Scholar
- 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.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.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