Database tuning principles, experiments, and troubleshooting techniques

Authors:
  • DSDennis Shasha
    Dennis Shasha
  • PBPhilippe Bonnet
    Philippe Bonnet
  • NBNancy Hartline Bercich
    Nancy Hartline Bercich

Abstract
As our reliance on computers and computerized data has increased, we have come to expect more from our computers. We no longer expect our computers to act as large expensive calculators that merely spit out bills and paychecks. We now, additionally, expect our systems to rapidly access and interactively present us with large volumes of accurate data. In fact, our expectations have changed so much, in the past decade, that we no longer focus on what our systems are but rather on what they do. We no longer refer to our systems as computer systems but rather information systems. With these new expectations have come new responsibilities for the information systems professional. We can no longer concern ourselves merely with keeping our systems up and running. We now need to concern ourselves with subjective concepts such as response time and throughput. With current expectations what they are, performance tuning has become vitally important.