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
RonHi 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