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)
Incoming Non-self Citations Over Time
Authors
- 1. Sanjay Agrawal
- 2. Surajit Chaudhuri
- 3. Lubor Kollar
- 4. Arun Marathe
- 5. Vivek Narasayya
- 6. Manoj Syamala
Incoming Citations (Sorted by Pagerank)
Showing 9 of 9 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 711 | A Case for A Collaborative Query Management System | 2009 | CIDR | 0.00017751589 |
| 1,534 | PerfXplain: Debugging MapReduce Job Performance | 2012 | VLDB | 0.00011468393 |
| 2,985 | DSB: A Decision Support Benchmark for Workload-Driven and Traditional Database Systems | 2021 | VLDB | 7.7795847e-05 |
| 3,354 | An Object Placement Advisor for DB2 Using Solid State Storage | 2009 | VLDB | 7.1837096e-05 |
| 3,779 | Instance-Optimized Data Layouts for Cloud Analytics Workloads | 2021 | SIGMOD | 6.7747205e-05 |
| 5,337 | Learned Index Benefits: Machine Learning Based Index Performance Estimation | 2022 | VLDB | 5.5635208e-05 |
| 8,389 | A Storage Advisor for Hybrid-Store Databases | 2012 | VLDB | 4.5296588e-05 |
| 9,956 | SCompression: Enhancing Database Knob Tuning Efficiency Through Slice-Based OLTP Workload Compression | 2025 | VLDB | 4.2373024e-05 |
| 11,217 | Efficient Approximation Framework for Attribute Recommendation | 2023 | SIGMOD | 4.1945683e-05 |
Previous
Page 1 / 1
Next
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 |
|---|---|---|---|---|
| 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 |
| 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 |
| 661 | Database Tuning Advisor for Microsoft SQL Server 2005 | 2004 | VLDB | 0.00018481174 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| Overall Rank | Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 12,450 | Online AutoAdmin (Physical Design Tuning) | 2007 | SIGMOD | 4.1945683e-05 |
| 7,862 | Database Tuning | 1992 | VLDB | 4.6330193e-05 |
| 286 | Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design | 2004 | SIGMOD | 0.00028990057 |
| 237 | An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server | 1997 | VLDB | 0.00031726304 |
| 5,060 | Index Interactions in Physical Design Tuning: Modeling, Analysis, and Applications | 2009 | VLDB | 5.7273583e-05 |
| 516 | AutoAdmin "What-if" Index Analysis Utility | 1998 | SIGMOD | 0.00021196031 |
| 158 | Automated Selection of Materialized Views and Indexes for SQL Databases | 2000 | VLDB | 0.00040071492 |
| 1,710 | Microsoft Index Tuning Wizard for SQL Server 7.0 | 1998 | SIGMOD | 0.00010807871 |
| 5,435 | Materialized View and Index Selection Tool for Microsoft SQL Server 2000 | 2001 | SIGMOD | 5.5043441e-05 |
| 661 | Database Tuning Advisor for Microsoft SQL Server 2005 | 2004 | VLDB | 0.00018481174 |