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.0001735831
Overall Rank: 493 | 96.70%
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,997	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.3938336e-05
8,225	Grep: A Graph Learning Based Database Partitioning System	2023	SIGMOD	5.3583852e-05
8,672	FusionInsight LibrA: Huawei’s Enterprise Cloud Data Analytics Platform	2018	VLDB	5.2753524e-05
8,780	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.2650571e-05
8,798	Automatic Indexing in Oracle	2025	VLDB	5.2606925e-05
8,902	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.2387388e-05
9,430	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	5.1658393e-05
9,754	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	5.115551e-05
9,895	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	5.1000511e-05
9,983	Wred: Workload Reduction for Scalable Index Tuning	2024	SIGMOD	5.0860177e-05
10,324	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	5.0241309e-05
10,366	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	5.0091669e-05
10,986	AutoLiquid: Autonomic Data Layout Optimization for the Databricks Lakehouse	2026	VLDB	4.9605343e-05
10,988	Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server	2026	VLDB	4.9605343e-05
11,443	SQL:Trek Automated Index Design at Airbnb	2025	VLDB	4.9605343e-05
12,982	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.9605343e-05
12,993	Bridging the Application and DBMS Profiling Divide for Database Application Developers	2007	VLDB	4.9605343e-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
89	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035265687
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028611216
196	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025581936
243	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023296011
380	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019530546
1,003	Multi-Dimensional Database Allocation for Parallel Data Warehouses	2000	VLDB	0.00012558273

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	756	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD
2	151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB
3	5,450	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD
4	10,988	Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server	2026	VLDB
5	380	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD
6	5,866	Compression Aware Physical Database Design	2011	VLDB
7	89	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
8	2,381	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB
9	12,982	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD
10	3,852	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD