• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 958
  • Last Modified:

MSDB Too Big


We have an msdb database on sql 2008 r2 which is over 3 GB in size;
The culprit is a tbale called DTA_tuninglog which has over 500,000 rows;
How is this table populated ? - do i need this information
or is it just some background SQL process that uses this info ?
Can i truncate it and stop it being populated ?

1 Solution
Steve WalesSenior Database AdministratorCommented:
The DTA_ tables are there because someone at some stage has used the Database Tuning Advisor

There was a question on cleanup of the DTA_tuninglog last year:


The documentation on the DTA is here:

Microsoft also provided a DTA cleanup script to use under certain circumstances (or, I suppose, if you don't want the DTA data anymore)

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now