Link to home
Start Free TrialLog in
Avatar of hraja77
hraja77

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Steve Wales
Steve Wales
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial