DBScholar

Back to papers

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

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 50 of 67 citing papers.

Rank Citing Paper Year Venue Pagerank
309 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.0002143249
321 Making Database Systems Usable 2007 SIGMOD 0.00021093212
702 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.0001464107
756 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014209974
1,072 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012143482
1,282 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011197535
1,400 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010759064
1,517 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010385462
1,696 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8272691e-05
1,706 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.804657e-05
1,936 ReStore: Reusing Results of MapReduce Jobs 2012 VLDB 9.3375824e-05
1,937 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.3333463e-05
2,190 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8848923e-05
2,290 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.6813363e-05
2,381 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.5299827e-05
2,481 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.3862675e-05
2,587 Tuning Schema Matching Software using Synthetic Scenarios 2005 VLDB 8.241309e-05
2,779 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.0085666e-05
2,784 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0021123e-05
2,864 Constrained Physical Design Tuning 2008 VLDB 7.9087048e-05
2,891 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.887378e-05
3,050 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.6969161e-05
3,081 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6515625e-05
3,361 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3621595e-05
3,456 Slalom: Coasting Through Raw Data via Adaptive Partitioning and Indexing 2017 VLDB 7.2673968e-05
3,614 Updating a Cracked Database 2007 SIGMOD 7.1420426e-05
3,818 Comprehensive and Efficient Workload Compression 2021 VLDB 6.983427e-05
3,852 Database Tuning Advisor for Microsoft SQL Server 2005: Demo 2005 SIGMOD 6.9614927e-05
3,890 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.926806e-05
3,951 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.8884038e-05
3,962 Storage Workload Estimation for Database Management Systems 2007 SIGMOD 6.8792824e-05
3,965 Cracking the Database Store 2005 CIDR 6.878328e-05
4,022 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8345671e-05
4,701 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.44638e-05
4,707 Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores 2017 VLDB 6.4422808e-05
5,046 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB 6.2884087e-05
5,149 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2382463e-05
5,272 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.1887235e-05
5,297 Only Aggressive Elephants are Fast Elephants 2012 VLDB 6.1773472e-05
5,304 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1758143e-05
5,645 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0354456e-05
5,866 Compression Aware Physical Database Design 2011 VLDB 5.9492579e-05
6,243 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8220831e-05
6,470 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.7564896e-05
6,779 Guided automated learning for query workload re-optimization 2019 VLDB 5.6686556e-05
6,954 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD 5.6196724e-05
7,424 Index Advisors on Quantum Platforms 2024 VLDB 5.5148364e-05
7,451 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.5106847e-05
7,844 Bespoke OLAP: Synthesizing Workload-Specific One-size-fits-one Database Engines 2026 VLDB 5.4255843e-05
7,921 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4098206e-05
Previous Page 1 / 2 Next

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
Previous Page 1 / 1 Next

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