Sizing DB2 UDB® servers for business intelligence workloads

  • Authors:
  • Ted J. Wasserman;Patrick Martin;Haider Rizvi

  • Affiliations:
  • School of Computing, Queen's University, Kingston, Ontario, Canada K7L 3N6;School of Computing, Queen's University, Kingston, Ontario, Canada K7L 3N6;IBM® Toronto Laboratory, Markham, Ontario, Canada L6G 1C7

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

Quantified Score

Hi-index 0.00

Visualization

Abstract

Computer system sizing involves estimating the amount of hardware resources needed to support a new application that has not been run in a production environment. Sizing assumes that little system environment information or performance measurements are available for the specific workload, thus a sizing expert must use extrapolations from similar workloads, industry benchmarks, rules-of-thumb, and hardware performance guidelines to determine the type and quantity of resources required. In this paper, we describe a structured approach to size the database tier of a business intelligence (BI) application. We also describe a prototype software tool we created based on the approach. We evaluate the tool using real customer data obtained from IBM and compare its results to the recommendations of a sizing expert.