Instructor Led Database Tuning Advisor Training Classes
From Boston University Corporate Education Center
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
...or Performance Performing Index Analysis by Using the Database Tuning Advisor (DTA)
After completing this unit, students will be able to:
Explain the methodology of optimizing the query environment. Describe the query performance troubleshooting process. Explain how Database Tuning Advisor can be used to troubleshoot the query environment. Review an execution plan for
more...
Updating Your Database Administration Skills to Microsoft SQL Server 2005
...e databases.
Lessons
? Managing Indexes ? Using the Database Tuning Advisor
Lab 5: Maintaining a Database
? Defining Indexes ? Tuning a Database
After completing this module, students will be able to:
? Maintain indexes in a SQL Server 2005 database. ? Use the Database Tuning Advisor to assist with database design. ? Maintain SQL Server 2005 databases.
Module 6:
more...
