Supporting capacity planning for DB2 UDB

  • Authors:
  • Hamzeh Zawawy;Patrick Martin;Hossam Hassanein

  • Affiliations:
  • School of Computing, Queen's University, Kingston, Ontario, Canada K7L 3N6 and IBM® Toronto Laboratory, Toronto, Ontario, Canada M3C 1H7;School of Computing, Queen's University, Kingston, Ontario, Canada K7L 3N6;School of Computing, Queen's University, Kingston, Ontario, Canada K7L 3N6

  • Venue:
  • CASCON '02 Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

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 DatabaseTM. We then give an example of how the model can be used to solve a typical capacity planning problem.