Solved

MSDB Too Big

Posted on 2012-12-31
1
886 Views
Last Modified: 2013-01-04
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
Comment
Question by:hraja77
1 Comment
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 38732706
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now