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: 9320
Venue: VLDB
Year: 2004
Pagerank: 0.0001738508
Overall Rank: 501 | 96.57%
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 14 of 64 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,490	FusionInsight LibrA: Huawei’s Enterprise Cloud Data Analytics Platform	2018	VLDB	5.4152314e-05
8,601	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	5.4048965e-05
8,783	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	5.3740362e-05
9,283	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	5.2925877e-05
9,715	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	5.2337048e-05
10,082	Wred: Workload Reduction for Scalable Index Tuning	2024	SIGMOD	5.1587525e-05
10,105	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	5.1435736e-05
10,139	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	5.093636e-05
10,535	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	5.093636e-05
11,003	Automatic Indexing in Oracle	2025	VLDB	5.093636e-05
11,019	SQL:Trek Automated Index Design at Airbnb	2025	VLDB	5.093636e-05
11,277	Index Advisors on Quantum Platforms	2024	VLDB	5.093636e-05
12,644	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	5.093636e-05
12,655	Bridging the Application and DBMS Profiling Divide for Database Application Developers	2007	VLDB	5.093636e-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
87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035281619
156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028636811
199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025612088
246	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.00023457421
387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019442332
995	Multi-Dimensional Database Allocation for Parallel Data Warehouses	2000	VLDB	0.00012758724

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	184	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB
2	768	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD
3	156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB
4	5,307	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD
5	387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD
6	5,755	Compression Aware Physical Database Design	2011	VLDB
7	87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
8	2,364	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB
9	12,644	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD
10	3,777	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD