Supporting capacity planning for DB2 UDB

ABSTRACT

Capacity planning is the process of determining the most cost-effective computing environment that meets the current and future demands of a computing system. Capacity planning is important for large database management systems (DBMSs) whose performance can be greatly affected by the amount of available resources and whose workloads can change significantly over time. In this paper, we examine support for capacity planning for DBMSs. We describe an analytical model that is used to estimate performance under different scenarios and discuss how to obtain the input parameters to the model for an OLTP workload running on IBM® DB2® Universal Database^TM. We then give an example of how the model can be used to solve a typical capacity planning problem.

REFERENCES

• 1: Edward D. Lazowska , John Zahorjan , G. Scott Graham , Kenneth C. Sevcik, Quantitative system performance: computer system analysis using queueing network models, Prentice-Hall, Inc., Upper Saddle River, NJ, 1984
• 2: Daniel A. Menascé , Virgílio A. F. Almeida , Larry W. Dowdy, Capacity planning and performance modeling: from mainframes to client-server systems, Prentice-Hall, Inc., Upper Saddle River, NJ, 1994
• 3: Shui F. Lam , K. Hung Chan, Computer capacity planning: theory and practice, Academic Press Professional, Inc., San Diego, CA, 1987
• 4: {4} Raj Jain, The Art of Computer Systems Performance Analysis, John Wiley & Sons Inc.1991.
• 5: Martin G. Kienzle , K. C. Sevcik, Survey of analytic queueing network models of computer systems, Proceedings of the 1979 ACM SIGMETRICS conference on Simulation, measurement and modeling of computer systems, p.113-129, August 13-15, 1979, Boulder, Colorado, United States
• 6: {6} L. Belady, A Study of Replacement Algorithms for a Virtual-Storage Computer, IBM Systems Journal 5 (2), July 1966.
• 7: {7} TPC Benchmarks, Transaction Processing Performance Council, http://www.tpc.org/information/benchma rks.asp, February 2002.
• 8: {8} M.E. Senko, V.Y. Lum, and P.J. Owens, A File Organization evaluation model, Proceedings IFIP Conference 1968, pp. 514-19.
• 9: Daniel A. Menascé , Virgílio A. F. Almeida, Capacity planning for Web performance: metrics, models, and methods, Prentice-Hall, Inc., Upper Saddle River, NJ, 1998
• 10: {10} Ken Sevcik, Data Base System Performance Prediction Using An Analytical Model, IEEE Computer, February 1981.
• 11: {11} D. Ferrari, Computer Systems Performance Evaluation, Prentice Hall, 1978.
• 12: {12} H. Zawawy, Capacity Planning for Database Management Systems using Analytical Modeling, M.Sc. thesis, Dept of Computing and Information Science, Queen's University, 2002.

INDEX TERMS

Primary Classification:
  C. Computer Systems Organization
  C.4 PERFORMANCE OF SYSTEMS
      Subjects: Modeling techniques

Additional Classification:
  C. Computer Systems Organization
  C.4 PERFORMANCE OF SYSTEMS
      Subjects: Design studies

  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.4 Systems
  H.3 INFORMATION STORAGE AND RETRIEVAL
      H.3.4 Systems and Software
          Subjects: Performance evaluation (efficiency and effectiveness)

General Terms:
Algorithms, Design, Experimentation, Measurement, Performance, Theory