Solved

MSDB Too Big

Posted on 2012-12-31
1
906 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Encrypting SQL Server 2014 or SQL Server 2016 4 30
t-sql need help on t-sql 10 26
SQL Group By Question 4 20
What is this datetime? 1 19
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

861 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