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

Machine Learning in Production: Developing and Optimizing Data Science Workflows and Applications (All-Inclusive)

Machine Learning in Production: Developing and Optimizing Data Science Workflows and Applications (All-Inclusive)

Machine Learning in Production: Developing and Optimizing Data Science Workflows and Applications

Machine Learning in Production: Developing and Optimizing Data Science Workflows and Applications

Programming Skills for Data Science: Start Writing Code to Wrangle, Analyze, and Visualize Data with R

Programming Skills for Data Science: Start Writing Code to Wrangle, Analyze, and Visualize Data with R