Database Tuning Advisor for Microsoft SQL Server 2005: Demo

Summary: Presents DTA for SQL Server 2005, integrating indexes, materialized views, and horizontal partitioning. Shows performance vs. manageability tradeoffs, offloading tuning to a test server, with scriptable guidance for indexes, MVs, and partitioning. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3784
Venue: SIGMOD
Year: 2005
Pagerank: 7.1347483e-05
Overall Rank: 3,777 | 74.09%
DOI: 10.1145/1066157.1066292

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

@inproceedings{agrawal_sigmod05,
        title = {{Database Tuning Advisor for Microsoft SQL Server 2005: Demo}},
        author = {Agrawal, Sanjay and Chaudhuri, Surajit and Kollar, Lubor and Marathe, Arun and Narasayya, Vivek and Syamala, Manoj},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066292},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066292},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,149	A Case for A Collaborative Query Management System	2009	CIDR	0.0001194728
1,694	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	9.9953156e-05
1,832	DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems	2021	VLDB	9.6607418e-05
3,035	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	7.8297746e-05
3,055	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.8079566e-05
4,643	Learned Index Benefits: Machine Learning Based Index Performance Estimation	2022	VLDB	6.5907466e-05
8,452	A Storage Advisor for Hybrid-Store Databases	2012	VLDB	5.4230061e-05
10,105	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	5.1435736e-05
11,418	Efficient Approximation Framework for Attribute Recommendation	2023	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 5 of 5 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
387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019442332
501	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.0001738508

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,644	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD
2	7,649	Database Tuning	1992	VLDB
3	199	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD
4	156	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB
5	4,550	Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications	2009	VLDB
6	387	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD
7	87	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
8	1,870	Microsoft Index Tuning Wizard for SQL Server 7.0	1998	SIGMOD
9	5,307	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD
10	501	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB