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.00017413042
Overall Rank
491 | 96.71%
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
314 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021282642
319 Making Database Systems Usable 2007 SIGMOD 0.00021164857
702 Database Architecture Evolution: Mammals Flourished long before Dinosaurs became Extinct 2009 VLDB 0.00014673738
751 Automatic Physical Database Tuning: A Relaxation-based Approach 2005 SIGMOD 0.0001425375
1,069 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012185253
1,279 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00011226878
1,397 Magic mirror in my hand, which is the best in the land? An Experimental Evaluation of Index Selection Algorithms 2020 VLDB 0.00010789242
1,516 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 0.00010402594
1,694 Self-organizing Tuple Reconstruction in Column-stores 2009 SIGMOD 9.8562172e-05
1,708 PerfXplain: Debugging MapReduce Job Performance 2012 VLDB 9.8224587e-05
1,924 ReStore: Reusing Results of MapReduce Jobs 2012 VLDB 9.3687009e-05
1,925 Here are my Data Files. Here are my Queries. Where are my Results? 2011 CIDR 9.3670488e-05
2,210 Lero: A Learning-to-Rank Query Optimizer 2023 VLDB 8.8257742e-05
2,275 Active Learning for ML Enhanced Database Systems 2020 SIGMOD 8.7090584e-05
2,373 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB 8.5606392e-05
2,478 Learning a Partitioning Advisor for Cloud Databases 2020 SIGMOD 8.4079121e-05
2,580 Tuning Schema Matching Software using Synthetic Scenarios 2005 VLDB 8.2716518e-05
2,772 Facilitating Database Tuning with Hyper-Parameter Optimization: A Comprehensive Experimental Evaluation 2022 VLDB 8.035288e-05
2,775 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0312847e-05
2,857 Constrained Physical Design Tuning 2008 VLDB 7.9380294e-05
2,882 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.9116043e-05
3,041 Configuration-Parametric Query Optimization for Physical Design Tuning 2008 SIGMOD 7.7215151e-05
3,073 Pushing Data-Induced Predicates Through Joins in Big-Data Clusters 2020 VLDB 7.6777283e-05
3,367 Exact Cardinality Query Optimization for Optimizer Testing 2009 VLDB 7.3719456e-05
3,445 Slalom: Coasting Through Raw Data via Adaptive Partitioning and Indexing 2017 VLDB 7.2943981e-05
3,606 Updating a Cracked Database 2007 SIGMOD 7.1686756e-05
3,815 Comprehensive and Efficient Workload Compression 2021 VLDB 7.0075744e-05
3,844 Database Tuning Advisor for Microsoft SQL Server 2005: Demo 2005 SIGMOD 6.9871379e-05
3,878 Stochastic Database Cracking: Towards Robust Adaptive Indexing in Main-Memory Column-Stores 2012 VLDB 6.9512776e-05
3,949 Deploying a Steered Query Optimizer in Production at Microsoft 2022 SIGMOD 6.9052796e-05
3,951 Cracking the Database Store 2005 CIDR 6.9039096e-05
3,952 Storage Workload Estimation for Database Management Systems 2007 SIGMOD 6.9034057e-05
4,007 Automated Generation of Materialized Views in Oracle 2020 VLDB 6.8592987e-05
4,690 Columnstore and B+ tree – Are Hybrid Physical Designs Important? 2018 SIGMOD 6.4687131e-05
4,702 Adaptive NUMA-aware data placement and task scheduling for analytical workloads in main-memory column-stores 2017 VLDB 6.4630351e-05
5,018 Breaking Down Memory Walls: Adaptive Memory Management in LSM-based Storage Systems 2021 VLDB 6.3121723e-05
5,131 Holistic Indexing in Main-memory Column-stores 2015 SIGMOD 6.2602133e-05
5,248 Endure: A Robust Tuning Paradigm for LSM Trees Under Workload Uncertainty 2022 VLDB 6.211056e-05
5,274 Only Aggressive Elephants are Fast Elephants 2012 VLDB 6.2005706e-05
5,286 An Efficient Transfer Learning Based Configuration Adviser for Database Tuning 2024 VLDB 6.1971399e-05
5,630 ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning 2022 SIGMOD 6.0582762e-05
5,853 Compression Aware Physical Database Design 2011 VLDB 5.9710387e-05
6,241 Operator and Query Progress Estimation in Microsoft SQL Server Live Query Statistics 2016 SIGMOD 5.8381762e-05
6,456 A Statistical Approach Towards Robust Progress Estimation 2012 VLDB 5.7782179e-05
6,764 Guided automated learning for query workload re-optimization 2019 VLDB 5.6873334e-05
6,932 Breaking Down Memory Walls in LSM-based Storage Systems 2020 SIGMOD 5.640907e-05
7,403 Index Advisors on Quantum Platforms 2024 VLDB 5.5357529e-05
7,425 An Automated, Yet Interactive and Portable DB Designer 2010 SIGMOD 5.5313491e-05
7,822 Bespoke OLAP: Synthesizing Workload-Specific One-size-fits-one Database Engines 2026 VLDB 5.4461624e-05
7,900 DISTILL: Low-Overhead Data-Driven Techniques for Filtering and Costing Indexes for Scalable Index Tuning 2022 VLDB 5.4303143e-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
88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB 0.00035351639
151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB 0.00028672526
195 Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design 2004 SIGMOD 0.00025628849
243 Automating Physical Database Design in a Parallel Database 2002 SIGMOD 0.00023358891
378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD 0.00019549382
1,002 Multi-Dimensional Database Allocation for Parallel Data Warehouses 2000 VLDB 0.00012598875
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 187 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB
2 151 An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server 1997 VLDB
3 5,430 Materialized View and Index Selection Tool for Microsoft SQL Server 2000 2001 SIGMOD
4 10,918 Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server 2026 VLDB
5 378 AutoAdmin "What-if" Index Analysis Utility 1998 SIGMOD
6 5,853 Compression Aware Physical Database Design 2011 VLDB
7 88 Automated Selection of Materialized Views and Indexes for SQL Databases 2000 VLDB
8 2,373 To Tune or not to Tune? A Lightweight Physical Design Alerter 2006 VLDB
9 12,934 Online AutoAdmin (Physical Design Tuning) 2007 SIGMOD
10 3,844 Database Tuning Advisor for Microsoft SQL Server 2005: Demo 2005 SIGMOD