Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
5  
Those are database tuning advisor tables that haven't been cleaned up. support.microsoft.com/kb/899634 –  swasheck Feb 18 '13 at 21:34

1 Answer 1

up vote 4 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

Your Answer

 
discard

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.