Production Database Systems: Making Them Easy is Hard Work

Enterprise capable database products have evolved into incredibly complex systems, some of which present hundreds of configuration parameters to the system administrator. So, while the processing and storage costs for maintaining large volumes of data have plummeted, the human costs associated with maintaining the data have continued to rise. In this presentation, we discuss the framework and approach used by the team who took Microsoft SQL Server from a state where it had several hundred configuration parameters to a system that can configure itself and respond to changes in workload and environment with little human intervention.

• Type: Conference
• Year: 2004
• Where: VLDB
• Authors: David Campbell
• Keywords: Configuration Parameters, Database, Enterprise Capable Database, Human Costs, VLDB 2004