Database Tuning Advisor for Microsoft SQL Server 2005

Summary: Integrated physical design advisor for SQL Server 2005: partitioning, indexes, materialized views. Optimizes performance with manageability constraints; scales with workload compression, reduced statistics, and test-server offload, via XML input/output schema. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9129
Venue: VLDB
Year: 2004
Pagerank: 0.00018481174
Overall Rank: 661 | 95.41%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 14 of 64 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,231	FusionInsight LibrA: Huawei’s Enterprise Cloud Data Analytics Platform	2018	VLDB	4.5539609e-05
8,391	Goals and Benchmarks for Autonomic Configuration Recommenders	2005	SIGMOD	4.5287897e-05
8,774	Tiresias: Enabling Predictive Autonomous Storage and Indexing	2022	VLDB	4.4559995e-05
9,203	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	4.3740313e-05
9,579	Kaizen: A Semi-Automatic Index Advisor	2012	SIGMOD	4.3236869e-05
9,929	Wred: Workload Reduction for Scalable Index Tuning	2024	SIGMOD	4.2510122e-05
9,956	SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression	2025	VLDB	4.2373024e-05
9,993	Leveraging Query Optimizers to Verify the Soundness of LLM-based Query Rewrites for Real-World Workloads, and More!	2026	CIDR	4.1945683e-05
10,247	Why Database Manuals Are Not Enough: Efficient and Reliable Configuration Tuning for DBMSs via Code-Driven LLM Agents	2026	VLDB	4.1945683e-05
10,774	Automatic Indexing in Oracle	2025	VLDB	4.1945683e-05
10,790	SQL:Trek Automated Index Design at Airbnb	2025	VLDB	4.1945683e-05
11,071	Index Advisors on Quantum Platforms	2024	VLDB	4.1945683e-05
12,450	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.1945683e-05
12,461	Bridging the Application and DBMS Profiling Divide for Database Application Developers	2007	VLDB	4.1945683e-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
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
237	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00031726304
285	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.0002899128
286	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00028990057
516	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00021196031
773	Multi-Dimensional Database Allocation for Parallel Data Warehouses	2000	VLDB	0.00016870159

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
258	DB2 Design Advisor: Integrated Automatic Physical Database Design	2004	VLDB	0.0003022091
1,017	Automatic Physical Database Tuning: A Relaxation-based Approach	2005	SIGMOD	0.00014634307
237	An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server	1997	VLDB	0.00031726304
5,435	Materialized View and Index Selection Tool for Microsoft SQL Server 2000	2001	SIGMOD	5.5043441e-05
516	AutoAdmin "What-if" Index Analysis Utility	1998	SIGMOD	0.00021196031
6,157	Compression Aware Physical Database Design	2011	VLDB	5.1801143e-05
158	Automated Selection of Materialized Views and Indexes for SQL Databases	2000	VLDB	0.00040071492
2,787	To Tune or not to Tune? A Lightweight Physical Design Alerter	2006	VLDB	8.1263608e-05
12,450	Online AutoAdmin (Physical Design Tuning)	2007	SIGMOD	4.1945683e-05
3,653	Database Tuning Advisor for Microsoft SQL Server 2005: Demo	2005	SIGMOD	6.8743355e-05