Online workload, performance and scalability of a database production system: A case study

Today, enterprises are seeking solutions to integrate their business functions by using advanced computing technologies. Meanwhile, these enterprises are cutting the information centers´ budgets to lower the costs. Computer downsizing becomes essential for cost saving. However, computer downsizing also threatens those enterprises whose business success depends heavily on delivering fast, accurate service to customers. System performance is the number one issue followed by the scalability. This paper presents an experimental study conducted on a system that mimicked a production system installed at a customer site. The experiment was designed to focus on the online work-load characterization and the performance evaluation when the use of the system changed along with the projected business growth