Index Tuning Wizard for Microsoft SQL Server 7.0 (and the AutoAdmin Project)
Surajit Chaudhuri
Microsoft
Abstract
The long term goal of the AutoAdmin initiative at Microsoft is
to make databases self-tuning and self-administering. In order
to achieve this goal, we exploit execution as well as optimization
information of the workload experienced by the database system.
Despite being a relatively young project, our innovations have
already enriched Microsoft SQL Server's upcoming release.
The index tuning wizard in SQL Server 7.0 is a contribution of the
AutoAdmin project. In this talk, I will provide an overview of the
AutoAdmin effort, present a demonstration of the Index Tuning Wizard
using SQL Server 7.0, and discuss the technical details of the index tuning
technology we developed.
Bio
Surajit Chaudhuri initiated and leads the AutoAdmin project at
Microsoft. Prior to joining Microsoft, he worked at
Hewlett-Packard Laboratories, Palo Alto. He holds a Ph.D from
Stanford University. Surajit has worked extensively on optimization
of decision-support queries as well as on integration of relational
and IR query systems. He is also involved with systems issues in
Data Mining. For more details, see
http://research.microsoft.com/~surajitc