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: h8285d8b2059adc58
Venue: SIGMOD
Year: 2005
Pagerank: 6.9838642e-05
Overall Rank: 3,845 | 74.16%
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,164	A Case for A Collaborative Query Management System	2009	CIDR	0.0001174008
1,515	DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems	2021	VLDB	0.00010418766
1,708	PerfXplain: Debugging MapReduce Job Performance	2012	VLDB	9.8184303e-05
2,765	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	8.0401855e-05
3,105	An Object Placement Advisor for DB2 Using Solid State Storage	2009	VLDB	7.6446275e-05
4,713	Learned Index Benefits: Machine Learning Based Index Performance Estimation	2022	VLDB	6.4543291e-05
8,612	A Storage Advisor for Hybrid-Store Databases	2012	VLDB	5.3017701e-05
10,340	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	5.0257853e-05
11,738	Efficient Approximation Framework for Attribute Recommendation	2023	SIGMOD	4.9769913e-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
88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00035340164
151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00028664776
195	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00025619089
378	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00019541534
492	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB	0.00017406029

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,940	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD
2	7,794	Database Tuning	1992	VLDB
3	195	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD
4	151	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB
5	4,609	Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications	2009	VLDB
6	378	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD
7	88	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB
8	1,906	Microsoft Index Tuning Wizard for SQL Server 7.0	1998	SIGMOD
9	5,434	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD
10	492	Database Tuning Advisor for Microsoft SQL Server 2005	2004	VLDB