DTA Tables in MSDB, safe to cleanup?

  • There appears to be a collection of tables in our MSDB database taking up a some 3.5GB of space. These tables are all prefixed with DTA_ (i.e. DTA_reports_index, DTA_reports_indexcolumn) and so I assume were created as part of some prior database tuning exercise?

    Is there a way I can safely flush the content of these tables, or preferably remove them as they are taking up space unnecessarily on a production server.

    Any advice you can provide is most appreciated.

    Many Thanks,

    John

  • I have just found the following link that may be appropriate however is it safe to make these changes on a live production server?

    http://support.microsoft.com/kb/899634

    Many Thanks,

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply