Home > Blogs > Database Engine Tuning Advisor

Database Engine Tuning Advisor

By  May 6, 2008

Topics: Data

You should be using the Database Tuning Advisor, or DBTA, to help you evaluate your system's performance and even your database design. But are you aware that this system needs a little maintenance?

The DBTA stores its "sessions" in the msdb system database. Make sure you include this database in your maintenance window, so that you retain this valuable information.

For more information on system tuning, make sure you check out this book preview from SQL Server 2005 Programming.

Share|Share on facebookShare on google

Become an InformIT Member

Take advantage of special member promotions, everyday discounts, quick access to saved content, and more! Join Today.

Other Things You Might Like

Applied Machine Learning for Data Scientists and Software Engineers: Framing--The First Steps Toward Successful Execution

Applied Machine Learning for Data Scientists and Software Engineers: Framing--The First Steps Toward Successful Execution

Pragmatic AI: An Introduction to Cloud-Based Machine Learning

Pragmatic AI: An Introduction to Cloud-Based Machine Learning

SQL Server 70-767: Implementing a Data Warehouse Using SQL LiveLessons (Video Training)

SQL Server 70-767: Implementing a Data Warehouse Using SQL LiveLessons (Video Training)