PAPER DIGEST
Most Influential SIGMOD 2005 Paper · 2026-03 edition

Database Tuning Advisor For Microsoft SQL Server 2005: Demo

Sanjay Agrawal, Surajit Chaudhuri, Lubor Kollar, Arun Marathe, Vivek Narasayya, Manoj Syamala

Venue
ACM SIGMOD Conference (SIGMOD) 2005
Recognition
Most Influential SIGMOD 2005 Paper (Rank No. 14)
Edition
2026-03
Impact factor
6
Certificate ID
3486120cddae7584

Abstract

Database Tuning Advisor (DTA) is a physical database design tool that is part of Microsoft's SQL Server 2005 relational database management system. Previously known as "Index Tuning Wizard" in SQL Server 7.0 and SQL Server 2000, DTA adds new functionality that is not available in other contemporary physical design tuning tools. Novel aspects of DTA that will be demonstrated include: (a) Ability to take into account both performance and manageability requirements of DBAs (b) Fully integrated recommendations for indexes, materialized views and horizontal partitioning (c) Transparently leverage a test server to offload tuning load from production server and (d) Easy programmability and scriptability.

Download PDF certificate