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

MSDB Too Big

Hi,

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 ?

thanks
H
0
hraja77
Asked:
hraja77
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:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_27456967.html

The documentation on the DTA is here:
http://msdn.microsoft.com/en-us/library/ms173494%28v=sql.105%29.aspx
http://msdn.microsoft.com/en-us/library/ms166575%28v=sql.105%29.aspx

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

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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