Sanjay Agrawal
ABSTRACT
Database Tuning Advisor (DTA) is a physical database design tool that is part of Microsoft's SQL Server 2005 relational database management system. Previously known as "Index Tuning Wizard" in SQL Server 7.0 and SQL Server 2000, DTA adds new functionality that is not available in other contemporary physical design tuning tools. Novel aspects of DTA that will be demonstrated include: (a) Ability to take into account both performance and manageability requirements of DBAs (b) Fully integrated recommendations for indexes, materialized views and horizontal partitioning (c) Transparently leverage a test server to offload tuning load from production server and (d) Easy programmability and scriptability.
- Agrawal, S., Chaudhuri, S., Kollar L., Marathe A., Narasayya V. and Syamala, M. Database Tuning Advisor For Microsoft SQL Server 2005. In Proceedings of the VLDB 2004 Conference, Toronto, 2004.Google Scholar
Cross Ref
- Agrawal, S., Narasayya V. and Yang, B. Integrating Vertical and Horizontal Partitioning Into Automated Physical Database. In Proceedings of the ACM SIGMOD, Paris, 2004. Google ScholarDigital Library
- Agrawal, S., Chaudhuri, S. and Narasayya V. Automated Selection of Materialized Views and Indexes for SQL Databases. In Proceedings of the 26th VLDB Conference, Cairo, 2000. Google ScholarDigital Library
- Chaudhuri, S. and Narasayya V. An Efficient, Cost-Driven Index Selection Tool for Microsoft SQL Server. In Proceedings of the 23rd VLDB Conference, Athens, 1997. Google ScholarDigital Library
- Chaudhuri, S. and Narasayya V. AutoAdmin "What-If" Index Analysis Utility. In Proceedings of the ACM SIGMOD, Seattle, 1998. Google ScholarDigital Library
- Chaudhuri, S. and Narasayya V. Index Merging. In Proceedings 15th International Conference on Data Engineering, Sydney, 1999. Google ScholarDigital Library
- Database tuning advisor for microsoft SQL server 2005: demo
Comments