Ideally, you would use the sample purge jobs provided by Microsoft.
There’s one table you can clean-up manually: dta_DebugTrace.
This table keeps track of run time of every single expression shape in every single orchestration (forever) – until you purge.
You can run this query to see how much history you have by year/month:
use BiztalkDTADB
[code:1:ec90262ef2]select datepart(year,dtTimeStamp),
datepart(month,dtTimeStamp),
count(*) as ‘rowcount’
from dta_DebugTrace
group by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp)
order by datepart(year,dtTimeStamp), datepart(month,dtTimeStamp) [/code:1:ec90262ef2]
To clean up this database, it is suggested you run the following:
[code:1:ec90262ef2]select * from dta_DebugTrace where dtTimeStamp < ‘2006-01-01′[/code:1:ec90262ef2]
Then after confirming the results, change the “select” to a “delete”.
You could try deleting a week or a month at a time, instead of all at once.