Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I ran Brent Ozar's sp_blitz on one of my production server. IT tagged a few tables in the MSDB database as being user created. They all follow the pattern dbo.DTA_*. Do these table come with MSDB, or were they added by something/someone?

share|improve this question
Those are database tuning advisor tables that haven't been cleaned up. – swasheck Feb 18 '13 at 21:34
up vote 7 down vote accepted

These are likely left over from Microsoft's Database Tuning Advisor. You should be able to get information about the sessions with this stored procedure:

EXEC sp_DTA_help_session

After identifying the sessions that you do not need you can remove them with this stored procedure supplying the session id using one as an example:

EXEC sp_DTA_delete_session 1
share|improve this answer
Correct. I flag them in sp_Blitz because they're not included in msdb by default. – Brent Ozar Jan 8 at 13:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.