Skip to main content
The Carolina Big-Data Group

Self-Managing DBMS Technology

April 29, 2005

Surajit Chaudhuri
Microsoft Research

The cost of ownership of any commercial database system is significant. The AutoAdmin project at Microsoft Research was started in late 1996 (well before the term Autonomic Computing became fashionable) to develop techniques to reduce the overhead of database administration. Our goal was to make it easier to monitor the server and develop self-tuning techniques for performance management. The technology from this project has been incorporated in the Database Tuning Advisor tool in upcoming SQL Server 2005 release (and earlier as Index Tuning Wizard in SQL Server 7.0 and SQL Server 2000). This talk will take a look at some of the past research results and discuss challenges and opportunities in self-tuning DBMS research.