Database Tuning Advisor for Microsoft SQL Server 2005

Proceedings 2004 VLDB Conference: The 30th International Conference on Very Large Databases (VLDB)

Volumn , Issue , 2004, Pages 1110-1121

  Agrawal, Sanjay ^a   Chaudhuri, Surajit ^a   Kollar, Lubor ^a   Marathe, Arun ^a   Narasayya, Vivek ^a   Syamala, Manoj ^a  

^a MICROSOFT   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 33745605073     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-012088469-8.50097-8     Document Type: Chapter

References (21)

1. The AutoAdmin project http://research.microsoft.com/dmx/AutoAdmin
2. S. Agrawal, S. Chaudhuri, L. Kollar and V. Narasayya Index Tuning Wizard for Microsoft SQL Server 2000. White paper. http://msdn.microsoft.com/library/techart/itwforsql.htm
3. S. Agrawal, S. Chaudhuri and V. Narasayya (2000) Automated Selection of Materialized Views and Indexes for SQL Databases. Proceedings of VLDB
4. S. Agrawal, V. Narasayya and B. Yang (2004) Integrating Vertical and Horizontal Partitioning Into Automated Physical database Design. Proceedings of ACM SIGMOD
5. R. Agrawal and S. Ramakrishnan (1994) Fast Algorithms for Mining Association Rules for Large Databases. Proceedings of VLDB
6. BMC Index Advisor http://www.bmc.com
7. S. Chaudhuri, A. Gupta and V. Narasayya (2002) Workload Compression. Proceedings of ACM SGMOD
8. S. Chaudhuri and V. Narasayya (1997) An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server. VLDB
9. S. Chaudhuri and V.A.A. Narasayya V. AutoAdmin (1998) “What-If” Index Analysis Utility. Proceedings of ACM SIGMOD
10. S. Chaudhuri and V. Narasayya (2000) Automating Statistics Management for Query Optimizers. Proceedings of ICDE
11. http://schemas.microsoft.com/sqlserver/2004/07/dta/
12. http://oth.oracle.com/products/oracle9i/index.html
13. LeccoTech's Performance Optimization Solutions for Oracle. White Paper, LeccoTech Inc http://www.leccotech.com
14. Program for TPC-D data generation with Skew ftp://ftp.research.microsoft.com/users/viveknar/TPCDSkew
15. J. Rao, C. Zhang, G. Lohman and N. Megiddo (2002) Automating Physical Database Design in a Parallel Database. Proceedings of the ACM SIGMOD
16. T. Stohr, H. Martens and E. Rahm (2000) Multi-Dimensional Aware Database Allocation for Parallel Data Warehouses. Proceedings of VLDB
17. H. TPC Benchmark Decision Support. http://www.tpc.org
18. G. Valentin, M. Zuliani, D. Zilio and G. Lohman (2000) DB2 Advisor: An Optimizer That is Smart Enough to Recommend Its Own Indexes. Proceedings of ICDE
19. World Wide Web Consortium (October 2000) Extensible Markup Language (XML). W3C Recommendation http://www.w3.org/XML/ Web-page
20. World Wide Web Consortium (May 2001) XML Schema, W3C Recommendation http://www.w3.org/XML/Schema Web-page
21. D. Zilio, et al. (2004) Recommending Materialized Views and Indexes with IBM's DB2 Design Advisor. Proceedings of International Conference on Autonomic Computing