Wednesday, March 7, 2012

MSDB up to 2GB due to DTA

I noticed my MSDB database is up over 2GB. Most of the data is in
DTA_tuninglog. Is there a process to purge this data? Can I simply delete
all the rows or will that cause an inconsistency with another table?
Thanks
Ron
Hi Ron,
I am not sure what version of the server you have running, however check
this link out as I think it may help you clean up the database:
http://support.microsoft.com/kb/899634
Take care.
~lb
"Ron" wrote:

> I noticed my MSDB database is up over 2GB. Most of the data is in
> DTA_tuninglog. Is there a process to purge this data? Can I simply delete
> all the rows or will that cause an inconsistency with another table?
> Thanks
> Ron

No comments:

Post a Comment