Database Tuning Advisor for Microsoft SQL Server 2005

Summary: SQL Server 2005’s DTA jointly recommends partitioning, indexes, and materialized views while honoring DBA manageability constraints—not just performance. Workload compression, limited statistics, test-server execution, and XML scripting enable scalable, customizable tuning. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: h2b70bdff4af719b5
Venue: VLDB
Year: 2004
Pagerank: 0.00017413042
Overall Rank: 491 | 96.71%
DOI: 10.1016/B978-012088469-8.50097-8

Incoming Non-self Citations Over Time

Authors

1. Sanjay Agrawal (Microsoft)
2. Surajit Chaudhuri (Microsoft)
3. Lubor Kollar (Microsoft)
4. Arun Marathe (Microsoft)
5. Vivek Narasayya (Microsoft)
6. Manoj Syamala (Microsoft)

BibTeX Citation

@article{agrawal_vldb04,
        title = {{Database Tuning Advisor for Microsoft SQL Server 2005}},
        author = {Agrawal, Sanjay and Chaudhuri, Surajit and Kollar, Lubor and Marathe, Arun and Narasayya, Vivek and Syamala, Manoj},
        journal = {PVLDB},
        series = {{VLDB} '04},
        pages = {1110--1121},
        doi = {10.1016/B978-012088469-8.50097-8},
        url = {https://doi.org/10.1016/B978-012088469-8.50097-8},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 67 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
7,977	The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions	2024	VLDB	5.4142519e-05
8,202	Grep: A Graph Learning Based Database Partitioning System	2023	SIGMOD	5.378708e-05
8,648	FusionInsight LibrA: Huawei’s Enterprise Cloud Data Analytics Platform	2018	VLDB	5.295083e-05
8,751	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.284914e-05
8,771	Automatic Indexing in Oracle	2025	VLDB	5.2806451e-05
8,872	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.2584643e-05
9,396	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	5.1853705e-05
9,853	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	5.1193944e-05
10,291	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	5.0431863e-05
10,297	Wred: Workload Reduction for Scalable Index Tuning	2024	SIGMOD	5.0430432e-05
10,333	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	5.0281656e-05
10,359	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	4.9793485e-05
10,916	AutoLiquid: Autonomic Data Layout Optimization for the Databricks Lakehouse	2026	VLDB	4.9793485e-05
10,918	Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server	2026	VLDB	4.9793485e-05
11,384	SQL:Trek Automated Index Design at Airbnb	2025	VLDB	4.9793485e-05
12,934	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.9793485e-05
12,945	Bridging the Application and DBMS Profiling Divide for Database Application Developers	2007	VLDB	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035351639
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028672526
195	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025628849
243	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023358891
378	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019549382
1,002	Multi-Dimensional Database Allocation for Parallel Data Warehouses	2000	VLDB	0.00012598875

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	187	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB
2	151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB
3	5,430	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD
4	10,918	Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server	2026	VLDB
5	378	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD
6	5,853	Compression Aware Physical Database Design	2011	VLDB
7	88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
8	2,373	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB
9	12,934	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD
10	3,844	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD