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
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

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 64 citing papers.

Rank Citing Paper Year Venue Pagerank
314 Making Database Systems Usable 2007 SIGMOD 0.00021574636
334 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00020875082
721 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014631814
768 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.00014173242
1,070 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.0001232307
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011361878
1,481 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010644613
1,548 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010392475
1,679 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 0.00010029136
1,694 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.9953156e-05
1,883 ReStore: Reusing Results of MapReduce Jobs 2012 VLDB 9.5421713e-05
1,927 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.4703074e-05
2,313 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.762627e-05
2,364 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.6869645e-05
2,420 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.605257e-05
2,499 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4993549e-05
2,538 Tuning Schema Matching Software using Synthetic Scenarios 2005 VLDB 8.4548936e-05
2,722 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.206711e-05
2,740 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.1855759e-05
2,811 Constrained Physical Design Tuning 2008 VLDB 8.0982817e-05
2,866 Optimal Column Layout for Hybrid Workloads 2019 VLDB 8.0175489e-05
3,003 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.8620915e-05
3,137 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.7204167e-05
3,413 Slalom: Coasting Through Raw Data via Adaptive Partitioning and Indexing 2017 VLDB 7.4326381e-05
3,426 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.4218997e-05
3,558 Updating a Cracked Database 2007 SIGMOD 7.3101789e-05
3,777 Database Tuning Advisor for Microsoft SQL Server 2005: Demo 2005 SIGMOD 7.1347483e-05
3,830 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 7.0877801e-05
3,876 Cracking the Database Store 2005 CIDR 7.0544298e-05
3,891 Storage Workload Estimation for Database Management Systems 2007 SIGMOD 7.0432571e-05
3,998 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9676473e-05
4,084 Comprehensive and Efficient Workload Compression 2021 VLDB 6.9151691e-05
4,101 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.9009734e-05
4,607 Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores 2017 VLDB 6.6088324e-05
4,637 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.592197e-05
5,039 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.3909067e-05
5,156 Only Aggressive Elephants are Fast Elephants 2012 VLDB 6.3410921e-05
5,171 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.3347618e-05
5,226 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB 6.3090383e-05
5,755 Compression Aware Physical Database Design 2011 VLDB 6.0974171e-05
5,766 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.094771e-05
5,869 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0610922e-05
6,138 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.9640712e-05
6,333 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.9094287e-05
6,828 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD 5.7601608e-05
6,938 Guided automated learning for query workload re-optimization 2019 VLDB 5.733869e-05
7,346 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.6377748e-05
7,750 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.5523652e-05
7,846 The Holon Approach for Simultaneously Tuning Multiple Components in a Self-Driving Database Management System with Machine Learning via Synthesized Proto-Actions 2024 VLDB 5.5331459e-05
8,042 Grep: A Graph Learning Based Database Partitioning System 2023 SIGMOD 5.5015896e-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
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
Previous Page 1 / 1 Next

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