patternsqlModerate
dbo.DTA_* tables in MSDB
Viewed 0 times
dbotablesmsdbdta_
Problem
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?
Solution
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:
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_help_sessionAfter 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 1Code Snippets
EXEC sp_DTA_help_sessionEXEC sp_DTA_delete_session 1Context
StackExchange Database Administrators Q#34975, answer score: 10
Revisions (0)
No revisions yet.